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 log

http://code.google.com/p/hppg/source/detail?r=1364