knutselsmurf Posted December 3, 2012 Share Posted December 3, 2012 I have a website with PrestaShop 1.4.9.0 which contains about 8500 products. Using memcache and running on a fast server. Site is pretty fast. Database is MYiSAM. Now I have made a new site (to replace the old one) with PrestaShop 1.5.2 from scratch. Database is INNODB, Same products, also memcache, same server. Site IS NOW DEADSLOW !!!!! No option in admin available anymore to change the database-tables from INNODB to MYiSAM ? PrestaShop 1.5.2 is fast enough for low amount of products, But if you have 1000 products or more: it gets slower and slower..... A multi-shop environment is not possible also when it's soo slow..... Any ideas ? Link to comment Share on other sites More sharing options...
clayton29657 Posted December 3, 2012 Share Posted December 3, 2012 I would suggest rolling back to 1.4.9 if you really do not need the upgrades that 1.5 offers. When i was using memcache that was a huge speed issue for my site. I use cloudflare and runs awesome.. Just a thought Link to comment Share on other sites More sharing options...
El Patron Posted December 3, 2012 Share Posted December 3, 2012 why not redo it with myiasm before making comparison? Link to comment Share on other sites More sharing options...
spiderspy Posted December 4, 2012 Share Posted December 4, 2012 ... Now I have made a new site (to replace the old one) with PrestaShop 1.5.2 from scratch. Database is INNODB, Same products, also memcache, same server. Site IS NOW DEADSLOW !!!!! No option in admin available anymore to change the database-tables from INNODB to MYiSAM ? .... Any ideas ? Youc can't change database-tables from INNODB to MYiSAM, only new install. P.S. INNODB needs much more system resources such as RAM. Link to comment Share on other sites More sharing options...
knutselsmurf Posted December 4, 2012 Author Share Posted December 4, 2012 why not redo it with myiasm before making comparison? I have made a new install with MYISAM: shop is much faster but still slow: 8500 products is too much... Will try to optimize MYSQL this week more, I will post the results later here. 1 Link to comment Share on other sites More sharing options...
Trip Posted December 5, 2012 Share Posted December 5, 2012 I already posted a snippet here http://www.prestashop.com/forums/index.php?/topic/207862-prestashop-its-your-hosthost-its-your-software/page__view__findpost__p__1025379 to benchmark. For mysql optimisation I recommned scripts like "mysqltuner" or "tuning primer" . They at least can show you the worst misconfigurations. Best regards, trip Link to comment Share on other sites More sharing options...
Ervins _Vishnevski Posted February 20, 2013 Share Posted February 20, 2013 In my case - switch off all unnecessary modules. Link to comment Share on other sites More sharing options...
Miguel Caires Posted February 23, 2013 Share Posted February 23, 2013 On my case, disabling RSS Feed Module did the trick! Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts