Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/www/domains/hppgallery_com/design/defaulttheme/tpl/pagelayouts/main.php on line 59

Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/www/domains/hppgallery_com/design/defaulttheme/tpl/pagelayouts/main.php on line 59
Wednesday, September 20, 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

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

Back »

Comments: 2

Leave a reply »

 
  • Subbu

    Awesome work!

    So pro!!!

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

     
     
  • http://rospher.com/

    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

Donate



Download