PS 1.6.0.9 Very very slow

[pandorrah]

 

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

Execution Load time (ms) config 339 constructor 0 init 179 checkAccess 0 setMedia 22 postProcess 0 initHeader 124 initContent 1721 initFooter 2 display 41

Hook processing: 140 ms / 3.12 Mb
8 methods called in 7 modules

Hook Processing displayBackOfficeHeader 1.46 Mb in 97 ms moduleRoutes 1.57 Mb in 39 ms actionAdminControllerSetMedia 0.09 Mb in 3 ms actionAdminPerformanceFormModifier 0.00 Mb in 0 ms displayAdminPerformanceForm 0.00 Mb in 0 ms displayAdminForm 0.00 Mb in 0 ms actionAdminPerformanceControllerBefore 0.00 Mb in 0 ms displayBackOfficeFooter 0.00 Mb in 0 ms actionDispatcher 0.00 Mb in 0 ms displayBackOfficeTop 0.00 Mb in 0 ms

Memory peak usage: 19.1 Mb

Execution Memory (Mb) Total (Mb) config 12.19 14.5 constructor 0.00 14.5 init 2.50 17.3 checkAccess 0.00 17.3 setMedia 0.09 17.3 postProcess 0.00 17.3 initHeader 1.59 17.4 initContent 0.71 19.1 initFooter 0.02 19.1 display 0.32 19.1

Total cache size (in Cache class): 0.31 Mb

DB type: DbPDO

SQL Queries: 26 queries

Time spent querying: 272 ms

Included files: 130

Size of included files: 3.18 Mb

Globals (> 1 Ko only): 1132 Ko

• _LANGADM ≈ 817.1 Ko
• _MODULES ≈ 146.6 Ko
• _MODULE ≈ 112.8 Ko
• context ≈ 43.9 Ko
• _SERVER ≈ 5.9 Ko
• _REQUEST ≈ 1.6 Ko
• _COOKIE ≈ 1.4 Ko
• _ENV ≈ 1.3 Ko

• Stopwatch
• Doubles
• Tables stress
• ObjectModel instances
• Files included

Stopwatch (with SQL_NO_CACHE) (total = 26)

Query Time (ms) Rows Filesort Group By Location

SELECT SQL_NO_CACHE COUNT(*) FROM `ps_group` LIMIT 1

106.231 5     in /home/pandorrah.nl/public_html/shopnw/classes/Group.php:225

from /controllers/admin/AdminPerformanceController.php:221
from /controllers/admin/AdminPerformanceController.php:571
from /controllers/admin/AdminPerformanceController.php:596
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /admin9535/index.php:54

SELECT SQL_NO_CACHE `id_product_attribute`FROM `ps_product_attribute`LIMIT 1

88.509 1     in /home/pandorrah.nl/public_html/shopnw/classes/ObjectModel.php:1466

from /classes/Combination.php:271
from /controllers/admin/AdminPerformanceController.php:181
from /controllers/admin/AdminPerformanceController.php:571
from /controllers/admin/AdminPerformanceController.php:596
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /admin9535/index.php:54

SELECT SQL_NO_CACHE * FROM ps_memcached_servers

46.859 1     in /home/pandorrah.nl/public_html/shopnw/classes/cache/CacheMemcache.php:200

from /controllers/admin/AdminPerformanceController.php:563
from /controllers/admin/AdminPerformanceController.php:578
from /controllers/admin/AdminPerformanceController.php:596
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /admin9535/index.php:54

SELECT SQL_NO_CACHE moduleFROM ps_tab_module_preferenceWHERE `id_tab` = 77AND `id_employee` = 1

17.994 1     in /home/pandorrah.nl/public_html/shopnw/classes/Tab.php:547

from /classes/controller/AdminController.php:1822
from /controllers/admin/AdminPerformanceController.php:592
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /admin9535/index.php:54

SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shopFROM `ps_configuration` cLEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

3.989 862     in /home/pandorrah.nl/public_html/shopnw/classes/Configuration.php:134

from /config/config.inc.php:116
from /admin9535/index.php:34

SELECT SQL_NO_CACHE `id_hook`, `name`FROM `ps_hook`UNIONSELECT `id_hook`, ha.`alias` as nameFROM `ps_hook_alias` haINNER JOIN `ps_hook` h ON ha.name = h.name

2.752 0     in /home/pandorrah.nl/public_html/shopnw/classes/Hook.php:131

from /classes/Hook.php:417
from /tools/profiling/Hook.php:60
from /classes/Dispatcher.php:413
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /admin9535/index.php:54

 

[JPresta.com]

Did you enabled smarty cache in Performances tab?

[pandorrah]

Yes i have.

[JPresta.com]

Can you keep profiling enabled so i can try on different pages?

[pandorrah]

Will do. One second...

[JPresta.com]

Also, why are you using a frame? This is hiding URL which is bad because:

• people cannot share a page
• people refreshing the page are redirected to home page

[pandorrah]

I like it to keep it clean, but if not needed i can disable it.

Should i disable?

[JPresta.com]

Yes I think you should.

 

Well, this is incredibily slow! I think your server AND MySQL are very slow, what is your hosting provider?

[pandorrah]

It's a local Dutch provider called ***********.nl

Edited February 12, 2015 by pandorrah (see edit history)

[JPresta.com]

Maybe they can have a look because it should not be that slow!

 

Or if you are just creating the site you may try Prestashop Cloud :-)

[pandorrah]

No it is a live site. Upgrading from PS 1.5 to 1.6 did not work, nor the SQL migration.
So i build it up from scratch again, and now the new site is very slow.

I'm creating a redirect page with full URL now, deleting the masked url.

[pandorrah]

Thank you, i will contact hem. I will update you with their answer.
Thank you for the assist.

[pandorrah]

I partially solved it:

1. in backend > modules > block categories> switch off dynamic.

2. in backend > advanced parameters > performance > smarty: recompile templates if edited YES, cache: YES, ccc: YES,YES,YES,NO,NO,NO, caching: NO.

 

These 2 alone boosted my performance in a huge way.

Also, via ftp: delete everyting in your cache folder once or twice a week. This also helps performance.

[zaurus]

I have a little bit different problem

Without cache my presta shop is running decent, let's say 4-5s load time for front

But when i set to on the caching, even if APC or Memcached or Redis the load time in front become 20s at first visit and almost 10s at reload (from cache)

 

Any ideas for this issue?

 

My server is a quad core with 32Gb and SSD's

I use there APC usually for opcode cache, CCC to on and all 3 media servers enabled

 

Regards

Bogdan

[El Patron]

I have a little bit different problem

Without cache my presta shop is running decent, let's say 4-5s load time for front

But when i set to on the caching, even if APC or Memcached or Redis the load time in front become 20s at first visit and almost 10s at reload (from cache)

 

Any ideas for this issue?

 

My server is a quad core with 32Gb and SSD's

I use there APC usually for opcode cache, CCC to on and all 3 media servers enabled

 

Regards

Bogdan

 

if you have 'different' problem, please post new topic, thanks.