very very slow prestashop

[mahmood.sajjadi]

hi

 

we have ecommerce website with prestashop(1.6.0.8) with more than +5000 visits per day

installed on a vps (2GB RAM - 4 core CPU - nginx+page_speed - xcache - php-fpm - mariadb)

 

but the server is too slow (the php limit execution time raise to 80s) but we have "bad gateway" error on nginx on most of all requests.

 

after analyzing the reports i noticed the slow inset queries on mysql

 

In some blogs i see (use prestashop for small-medium / magento for large-scale business)

 

am i forced to migrate to magento? or is there any solution for prestashop?

 

best regards

[Mr Rick]

Hi,

 

Actually Magento is slower than PrestaShop

 

I think you need a better dedicated server.

[El Patron]

anytime you have slow page, you should turn on PrestaShop profiling to get idea of where PS is spending it's time.

 

config/defines.inc.php

 

set this to true (note anyone coming to shop will see this so set to false after collecting data)

define('_PS_DEBUG_PROFILING_', false);

[mahmood.sajjadi]

hi and regards

 

this is the result but i have no idia how to make my site faster than  a toaster

Load time: 2018 ms
You'd better run your shop on a toaster

Execution Load time (ms) config 346 constructor 0 init 279 checkAccess 0 setMedia 1 postProcess 0 initHeader 0 initContent 1361 initFooter 5 display 25

 

Memory peak usage: 19.2 Mb

Execution Memory (Mb) Total (Mb) config 9.88 11.6 constructor 0.00 11.6 init 0.69 12.5 checkAccess 0.00 12.5 setMedia 0.04 12.5 postProcess 0.00 12.5 initHeader 0.00 12.5 initContent 6.31 18.5 initFooter 0.14 18.5 display 0.76 19.2

 

[vekia]

do you use some caching extensions?

they can boost your shop!

[mahmood.sajjadi]

first of all thanks for your replay

 

yes i used xcache. but i can use any other systems like eaccelerator ,opc ,apc, memcache or ....(is there any diffrence between them?)

 

i disabled CCC and other feature inside prestashop becuse i used pagespeed mmodule for nginx

 

please help me to how find the issue and what is the parameters listed in PROFILING_MODE

 

after all this is my website : http://clothing.roozemehmooni.com

 

best regards