chrasty Posted February 25, 2014 Share Posted February 25, 2014 (edited) Hello,i imported 250 000 products for 4 languages. Multistore allowed.Shop is very slow. In one category is 75 000 products and page loading take 18 seconds. Server:CPU: Intel Xeon L3426 4C/8T 1.86 GHz 8 MB8 GB DDR3 1066 MHz 2 x SAS 3G 146GB 15k, HW RAID .htaccessphp_value max_execution_time 1600php_value memory_limit 1512Mphp_value max_input_time 1200php_value default_socket_timeout 480php_value mysql.connect_timeout 480php_value query_cache_size 128M How can I speed up page load under 3 seconds? Thank you for help Edited February 25, 2014 by chrasty (see edit history) Link to comment Share on other sites More sharing options...
prestamax Posted February 25, 2014 Share Posted February 25, 2014 You should enable caching. According to your screenshot you have set "use cache" to "no" (only template cache is enabled) Link to comment Share on other sites More sharing options...
chrasty Posted February 25, 2014 Author Share Posted February 25, 2014 You should enable caching. According to your screenshot you have set "use cache" to "no" (only template cache is enabled) Yes, i tried it, but it have not any effect. I have installed APC on server. I think that problem will in mysql, but i do not know how repair that. Link to comment Share on other sites More sharing options...
prestamax Posted February 25, 2014 Share Posted February 25, 2014 (edited) Is your shop online and would you share a link for being able to check it? Did you try file caching if APC is not working? Edited February 25, 2014 by prestamax (see edit history) Link to comment Share on other sites More sharing options...
selectshop.at Posted February 27, 2014 Share Posted February 27, 2014 (edited) Better is a fast-cgi opcode caching system with balance loading distributed on several servers. Prestashop 1.6.03 is the fasted version I've ever tested. Only 10.000 products, but 300 filter options which make all server slow.... Did you tried to use medai-servers for to outsource data ? Cloud (CDN) could solve your problem... Edited February 27, 2014 by selectshop.at (see edit history) Link to comment Share on other sites More sharing options...
kbytin Posted March 25, 2014 Share Posted March 25, 2014 My shop also was very slow. I've set a lot of tags to display in Blocktags and also set to default quantaty of related products and products from same category. Now it is fast. Link to comment Share on other sites More sharing options...
Zigi M Posted September 18, 2014 Share Posted September 18, 2014 @chrasty did you solve the problem?? i am having the same issue. 20k products with attributes and multiple languages runing on a good vps. i can not go live with the site. Link to comment Share on other sites More sharing options...
El Patron Posted October 18, 2014 Share Posted October 18, 2014 for 'anyone' with slow pages, one should obtain critical PrestaShop profiling information for slow page(s). This may make it very simple to find the problem area. To not do this just leads to a lot of guessing. open file config/defines.inc.php and set value to true, visit slow page(s), scroll down, collect profiling information for later analysis. define('_PS_DEBUG_PROFILING_', false); note: when set to true all front and back office visitors will see the profiling information, so turn off when you have finished collecting information. tip: for 1.6 shops (for 1.6.0.7 and higher) bo-->advanced parms-->performance (set javascript load bottom). for pre 1.6 shops (1.5) or 1.6 with themes not compatible with move all javascript bottom, then see JavaPro module. Moving javascript to bottom will create a much faster above the fold page render, nobody really cares how long your footer takes to load. Link to comment Share on other sites More sharing options...
Recommended Posts