Hi David
I have a VPS running with over 120K products on 1 database.
I have done a few modifications to the script to suite my needs.
What I am experiencing is when I click on "Electronics" category. (Which has the most products, almost 100K)
The site "loads", more like pauses sometime before the page loads.
The page load time shows under 1s therefor I cant understand the time take to display the page?
The second time one clicks on the category it then loads fast.
What can I do to speed things up?
Hi Andrew,
The second time will be faster because MySQL will have the query cached from the previous page load. Have you come across the following thread with lots of discussion and tips for running very large Price Tapestry site?
http://www.pricetapestry.com/node/732
Cheers,
David.