deech123 Posted June 4, 2010 Share Posted June 4, 2010 Hi Guys,I have done some tests on the testserver (very fast server) and live server.I have over 1200 categories in the table category_lang.I even didn't upload 23000 products, and the site is sooooooo slow...almost not usable.is there any reason (indexing?) why the system must work so damn hard to build the navigation?is there a maximum of categories?I think the slow time is caused of the building of the navigation.is there a way to build the second level only when someone click on the first level?in that case we can save an enormous load each time a page refreshes. Link to comment Share on other sites More sharing options...
rocky Posted June 4, 2010 Share Posted June 4, 2010 Yes, the standard category module loads every category on every page using recursive Smarty templates. When there are many categories, this can really slow down your site. My AJAX Sliding Categories module gets around this issue by loading only the top level of categories and then loading the subcategories using AJAX only when required. There is also a free module available here that removes the recursive Smarty templates from the category module to speed it up. Link to comment Share on other sites More sharing options...
tomerg3 Posted June 5, 2010 Share Posted June 5, 2010 Check your mysql slow queries log, I helped someone with a similar situation where over 1,000 categories was taking a really long time to load.More hosts have a /tmp/mysql_slow_queries folders with files (named by date).If you post a few of them here, I'll try to help. Link to comment Share on other sites More sharing options...
PauloPaulo Posted June 5, 2010 Share Posted June 5, 2010 Please check your mysql slow queries log. I have the same problem! Link to comment Share on other sites More sharing options...
deech123 Posted June 6, 2010 Author Share Posted June 6, 2010 Hi couldn't find them on my hosted server....but I solved the problem with this help (http://www.prestashop.com/forums/viewthread/5860/#199706)now in testphase over 1200 categories spread over 3 levels.load time went from 15-29 seconds to 1 second max. Link to comment Share on other sites More sharing options...
everyz Posted June 22, 2010 Share Posted June 22, 2010 Hi couldn't find them on my hosted server....but I solved the problem with this help (http://www.prestashop.com/forums/viewthread/5860/#199706)now in testphase over 1200 categories spread over 3 levels.load time went from 15-29 seconds to 1 second max. You should also use some opcache (like eaccelerator) - helps when you need to load many files from disk. Link to comment Share on other sites More sharing options...
Recommended Posts