Hello all, I'm trying to find out the solutions for my blog site optimization. I've optimized all images but it helps decreasing download time only 2 seconds. The database of my site is very big; Thailand-TravelOnline dot com. Any suggestion? Tnx.
I suggest running your queries through phpmyadmin and finding out how fast they go, then optimise any queries taking a long time. You can do this easily by adding indexes to your tables.
If you want people from outside thailand move the server to outside thailand since the internet is thailand is so slow even servers
Yellowberry.org was the only one that got it right... to everyone else, despite the thread title, he wants the total page load time reduced, not the script execution time which is probably only a fraction of that time. - Compress images and use the most suitable format - Use GZip on most content, especially static/dynamic pages, images, CSS and JS (possibly the easiest and most efficient step) - Make sure content is loaded in the optimal order, scripts last, styles first. Yahoo's Developer centre has some nice notes about speeding up the process and I highly recommend Firebug and YSlow extensions for Firefox to profile your page load time.
Make sure that your mysql queries are only retrieving the fields that it needs to rather than doing a "select *" (meaning all) just ensure you are doing the minimal amount of retrieving that you can. Also, make sure you are running on a reasonable speed server, don't just worry about the bandwidth issue. My sites used to take a couple of seconds to generate pages when they were on a host with lots of sites, now that they're on our server they generate in "0.01 seconds" lol, nice and quick.