Gallery performance improved by 10%
Because of todays changes gallery performance was improved by another 10 percents. Read more to know how this was archieved.
Based on various MySQL performance improvement tips I found one, which I knew for a long time, but could'nt find a time to implement it. What is says:
"You should select columns you actualy need."
Basicaly previously in every part - gallery was selecting all image attribues, even for lists. So I decided to change this. So now almoust all listings are fetching only attributes they actually need, including sphinx search, last rated, last commented etc. This gave us nice around 10% improcement on non cached pages.
What was changed you can see in this change logBack »