Can not turn on PS_DEBUG_PROFILING in FrontOffice

[CoolTom]

Hi, our eshop start loading really slow. My guess is, that is must be connected with count of product (around 9.000 total)? Running multistore with 5 eshops.

 

I was trying enable define(‘PS_DEBUG_PROFILING’, true); in file 0:/www/config/defines.inc.php but nothing show in front office. Using Transformer template and maybe it block it somehow. Just not able see profiling on the end of page. Working in Back office.

 

What can be the problem?

 

thank you for ideas

Edited April 13, 2016 by CoolTom (see edit history)

[tuk66]

Can we see it online?

[CoolTom]

Sure, here. All one instalation - multistore. PS 16.0.6, Transformer template, last version

 

http://www.reklamapro.cz (about 2550+variants)

http://www.reklamaone.cz (about 2024+variants)

http://www.svickyone.cz (31)

http://www.darkyone.cz (166+varinats) - most fastes from all

http://www.kalendareone.cz (about 3689 + variants)

 

I find out that there was big delay when DB working on "Copying to tmp table" SELECT p . * , product_shop . * , stock.out_of_stock, IFNULL( stock.quantity, 0 ) AS quantity, MAX( product_a ....

It took like 30-40s to finish it and then it load page (basically all pages with products). It was Featured Products plugin and it does selection from home category (ID2) what mean from all products (every multistore eshop root cat in below Home).

 

But even now, when you browse any page (CMS pages are faster) it still take long time (up to 10-12s), before browser load page.

 

Smarty cache is on. I also try switch on all CCC, but not big different.

 

Thnx in advance

Edited April 13, 2016 by CoolTom (see edit history)

[tuk66]

Consider also server tuning. It seems the database is very slow (overloaded, unoptimized or on slow disks). I would try the database on SSD, with enough memory for cache.

[CoolTom]

I had it on own server and moved it to more powerful (but shared) web hosting.Can not tune anything about DB

 

So you think its db performance only? Can it be some inconsistency in DB (products, variants).

 

I am afraid use Presta Cleaner module to "clean/fix" DB, because it do something first and then tell you what was done / deleted ....

 

Do u have idea, why I can not see PS_DEBUG_PROFILING in front end?

 

Thanks a lot

 

Tomas

[CoolTom]

Any idea, why PS_DEBUG_PROFILING doesn't show in Front End? Thank you