Wednesday, January 18, 2017

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 log

Back »

Comments: 2

Leave a reply »

  • Subbu

    Awesome work!

    So pro!!!

    I will be re-starting my gallery site with this script soon...


    I'm really satisfied to find this site.I need to thank you only for this brilliant read!!I unquestionably loved each and every piece of it and likewise have you bookmarked to see new stuff on your site.

  • Leave a Reply
    Your gravatar
    Your Name
About HPPG

High performance photo gallery dedicated for large numbers of image storage.

Get in touch