Petrnek Posted January 3, 2008 Share Posted January 3, 2008 Hi all, i have a store, that doesn't have as many products (well, some thousands) but has them duplicated in many categories. This creates over 17000 items. The first initial index page rendering is over 50secs. Then, the response is faster, but still ot perfect. I populate my site through easy populate. If anyone is interested, i would be glad to provide my data for testing purposes to optimize the code. Interestingly enough, when i had just one top category, all was _quite_ OK, but now, after adding second one, the performance decreased dramatically. Any idea for optimization? You can check it at spares.robe.cz Thank you Petr Link to comment Share on other sites More sharing options...
daveboyce Posted January 3, 2008 Share Posted January 3, 2008 ...if you have access to the set-up of the database could you turn on some kind of query caching (depending on database)? That might make those pages load a lot more quickly. Link to comment Share on other sites More sharing options...
edschaum Posted January 3, 2008 Share Posted January 3, 2008 Hi all, i have a store, that doesn't have as many products (well, some thousands) but has them duplicated in many categories. This creates over 17000 items. The first initial index page rendering is over 50secs. Then, the response is faster, but still ot perfect. I populate my site through easy populate. If anyone is interested, i would be glad to provide my data for testing purposes to optimize the code. Interestingly enough, when i had just one top category, all was _quite_ OK, but now, after adding second one, the performance decreased dramatically. Any idea for optimization? You can check it at spares.robe.cz Thank you Petr Wow, that's slow! With that many products, you probably need to be on a dedicated server, especially if you get a lot of traffic. Shared hosting just won't cut it with a big store. You might consider getting rid of the "new products for..." box, I think that uses a lot of processing power to display. Check out Chemo's store optimization thread. Run Analyze and then Optimize on your tables...every day. Cache your categories box and get rid of the code that counts and displays the number of products on the categories box. There's probably more that you can do to speed things up, but these should help a bit. Ed Link to comment Share on other sites More sharing options...
Petrnek Posted January 4, 2008 Author Share Posted January 4, 2008 Wow, that's slow!You might consider getting rid of the "new products for..." box, I think that uses a lot of processing power to display. ... Great, thank you, i will try your suggestions and will let you know:) Cheers Petr Link to comment Share on other sites More sharing options...
Petrnek Posted January 4, 2008 Author Share Posted January 4, 2008 Wow, that's slow! Ed Dear Ed, just turning off the count and the new products made the store rendering go down very dramatically! You can check! I will look up some more things and thank you for the quick advice once again, Cheers Petr Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.