CUBE-IN Posted July 26, 2012 Share Posted July 26, 2012 (edited) Hi, i'm working on new shop on presta 1.5. Almost done, but i have a big problems with the speed of DB querries. A have more than 10 000 products in category with a lot of features and the DB query for list category products runs for 1.5 seconds I have my own dedicated server, load is less than 10%. Ajax searching with autocomplete is slow too. Any ideas about that? If you wanna see my shop, try www.pneumatikator.cz Slow category list for example: http://www.pneumatikator.cz/8-letni-pneumatiky-osobni Thank you, Roman Edited July 26, 2012 by CUBE-IN (see edit history) 1 Link to comment Share on other sites More sharing options...
David G. Posted July 26, 2012 Share Posted July 26, 2012 try enabling cache. APC is my suggestion. You need to have it installed on your server, as a php extension in most cases. Link to comment Share on other sites More sharing options...
CUBE-IN Posted July 26, 2012 Author Share Posted July 26, 2012 try enabling cache. APC is my suggestion. You need to have it installed on your server, as a php extension in most cases. I have filesystem cache enabled. I tried memcache, but the response was 3 times slower Do you think APC will be better? Link to comment Share on other sites More sharing options...
Trip Posted July 26, 2012 Share Posted July 26, 2012 I don't know if filesystem cache is working better now but a couple of versions ago it was complete horror as it created millions of directories. I was glad that I did not use it on a live system. I second that memcached was a performance decrease when I tried it with 1.4.8. which is really strange. I would first try to disable(if possible) filesystem cache. In earlier versions you could do benchmarks by deleting the underscore of some controllers in the override folder to find some bottlenecks. I don't know if this is possible at the moment. Best regards, trip Link to comment Share on other sites More sharing options...
David G. Posted July 27, 2012 Share Posted July 27, 2012 In my experience, APC is quite fast. Didn't deploy on a production server yet, but in our development machine seems stable. Mind that the dev machine doesn't have all the catalog, so it might look different once deployed on the production one. Link to comment Share on other sites More sharing options...
Trip Posted July 28, 2012 Share Posted July 28, 2012 APC is a php opcode cache so it is not really connected to the database performance but anyway I found out that there is a test script to see if apc is working correct. In my case I had to increase memory limit because it was fragmented. You can find the script under /usr/share/doc/php-apc/apc.php.gz Increase memory size in apc.ini like: extension=apc.so apc.enabled = 1 apc.shm_segments = 1 apc.shm_size = 50 There are some scripts like tuning-primer.sh or mysqltuner.pl which might help you to optimize mysql server. Best regards, trip Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts