1.7 Baaardzo wolne działanie sklepu

[Rymek]

Cześć !

Mam problem . Postawiłem sklep na 1.7 Zacząłem import z xml, csv zrobiło sie 50tys produktów.

Sklep od momentu wpisania adresu baaaardzo wolno sie ładuje , później po kliknieciu w produkt jeszcze gorzej.

Mam kilka pytan.

1.Jak to przyspieszyc ? testowalem wszystkie opcje wbudowane włącznie z memcached i nic sie nie polepsza.

2.Jak usunąć stare zdjęcia nieużywane ? Bo przekroczyłem już 2mln plików na hostingu.

3.Baza danych ma 800mb to normalne ?

Zmieniłem już hosting nic nie dało.

Nie mam już pomysłów.

HELP !

sklep: tusiekupuje.pl

Czasy wczytywania sa 8-9 sek produktu.

[rrataj]

Wszystko wskazuje na to że import produktów był przeprowadzony w sposób nieoptymalny... Teraz może być ciężko to zoptymalizować, być może lepiej będzie zaimportować ponownie w inny sposób. Czy te 50 tysięcy produktów ma kombinacje?

[Rymek]

Cześć dzięki za odpowiedź

 

Dziwne bo korzystam z eMagicOne managera.

Zwalałem to na hosting.

Kombinacji na razie nie ma miałem je tworzyć

Dziwi mnie długi czas reakcji serwera na samym początku dlatego próbuje z innym hostingiem.

Co może pomóc oprócz ponownego importu strasznie dużo tego.

[krzysiek_web]

Sprawdziłeś profilowanie? Bez produktów także mieli? 

[Rymek]

Widzisz, zachowałem sie jak debil.

Dostałem sklep postawiony przez jakąś firme nie sprawdziłem nic.

Ponieważ mam dedlina do konca listopada rzuciłem sie na zdobywanie plikow od hirtowni i imporcie.

Zaufałem że jest dobrze na dobrym hostingu.

Teraz mam dupe zbitą i 2mln plikow na serwerze i szukam hostingu lub VPS-a

Nie nie sprawdziłem....... w 1.6 to bylo w configu ? a w 1.7 gdzie jest ?

 

[krzysiek_web]

defines.inc.php

Nie masz kopii zapasowej ze stanu przed zmianami? 😲

[Rymek]

Mam ale to juz chyba było po fakcie.

Po mi sie nadpisała.

Ogólnie dramat.... :

Próbowałem wszystkiego jeszcze dziś zmieniam na próbe hosting ale sadze ze nic nie wskoram.

A na Page Cached nie chce wydawac 400PLN jak nie pomoze.

Lazy Load nie pomaga memcached tez nie... gdzies jest wałek juz na starcie i odpowiedzi serwera widziales jak to wolno sie laduje ?

Jakies rady zeby znow nie importowac ?

HEELP !

 

PS_DEBUG_PROFILE true ? 

Edited November 13, 2020 by Rymek
EDIT (see edit history)

[krzysiek_web]

Tak. 

Ja na tusiekupuje mam 500. 

[Rymek]

Bo wlaczylem debuga.

 

Load Time480 ms - Unicorn powered webserver!

Querying Time49 ms

Queries49

Memory Peak Usage42.6 Mb

Included Files1170 files - 10.30 Mb

PrestaShop Cache0.37 Mb

Global vars0.40 Mb

PrestaShop Version1.7.4.2

PHP Version7.4.11 (OK)

MySQL Version10.3.24-MariaDB-cll-lve (OK)

Memory Limit128M

Max Execution Time180s

Smarty Cacheenabled

Smarty Compilationforce compile

 TimeCumulated TimeMemory UsageMemory Peak Usage

config281ms281 ms32.04 Mb32.07 Mb

__construct0 ms281 ms- Mb32.07 Mb

init93ms374 ms8.28 Mb40.94 Mb

checkAccess0 ms374 ms- Mb40.94 Mb

setMedia5 ms379 ms0.77 Mb41.34 Mb

postProcess0 ms379 ms- Mb41.34 Mb

initHeader5 ms383 ms0.44 Mb41.51 Mb

initContent0 ms383 ms- Mb41.51 Mb

initFooter3 ms386 ms0.16 Mb41.73 Mb

display93ms480 ms0.79 Mb42.63 Mb

HookTimeMemory Usage

0 hooks- ms- Mb

ModuleTimeMemory Usage

0 modules- ms- Mb

Stopwatch SQL

Doubles

Tables stress

ObjectModel instances

Included Files

Stopwatch SQL - 49 queries

QueryTime (ms)RowsFilesortGroup ByLocation

SELECT SQL_NO_CACHE r.`slug` FROM `ps_authorization_role` r WHERE r.`id_authorization_role` IN ( SELECT a.`id_authorization_role` FROM `ps_access` a WHERE a.`id_profile` = "1" union all SELECT ma.`id_authorization_role` FROM `ps_module_access` ma WHERE ma.`id_profile` = "1" )

21.41000/classes/Access.php:115

SELECT SQL_NO_CACHE r.`slug` FROM `ps_authorization_role` r WHERE r.`id_authorization_role` IN ( SELECT a.`id_authorization_role` FROM `ps_access` a WHERE a.`id_profile` = "1" union all SELECT ma.`id_authorization_role` FROM `ps_module_access` ma WHERE ma.`id_profile` = "1" )

5.71000/classes/Access.php:115

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`

1.7200YesYes/classes/Hook.php:629

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`

1.6176YesYes/classes/Hook.php:629

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`

1.4176YesYes/classes/Hook.php:629

SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name

1.40/classes/Hook.php:186

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_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

1.1751/classes/Configuration.php:157

SELECT SQL_NO_CACHE t.*, tl.name FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE 1 ORDER BY t.`position` ASC

1.1156Yes/classes/Tab.php:277

SELECT SQL_NO_CACHE * FROM `ps_hook` h ORDER BY `name`

1.1269Yes/classes/Hook.php:149

SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`

1200YesYes/classes/Hook.php:629

SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1

0.5100/classes/module/Module.php:301

SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC

0.547Yes/classes/Dispatcher.php:530

SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 1) ORDER BY `name` ASC

0.47Yes/classes/QuickAccess.php:67

SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`

0.4156/classes/Tab.php:314

SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 7

0.41/classes/ObjectModel.php:1613

SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1

0.41/classes/Language.php:1028

SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)

0.41/classes/module/Module.php:2066

SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.`id_employee` = c.`id_employee` AND c.`id_shop` = 1 WHERE (a.`id_employee` = 7) LIMIT 1

0.31/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE `iso_code` FROM `ps_country` WHERE `id_country` = 14 LIMIT 1

0.31/classes/Country.php:271

SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 14) LIMIT 1

0.31/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name

0.31/classes/shop/Shop.php:692

UPDATE `ps_employee` SET `last_connection_date` = CURRENT_DATE() WHERE `id_employee` = 7 AND `last_connection_date`< CURRENT_DATE()

0.31/classes/Employee.php:645

SELECT SQL_NO_CACHE * FROM `ps_hook_alias`

0.383/classes/Hook.php:249

SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1

0.31/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 14) LIMIT 1

0.31/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)

0.31/classes/Language.php:881

SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 101 LIMIT 1

0.31/classes/Tab.php:229

SELECT SQL_NO_CACHE e.`id_employee` FROM `ps_employee` e WHERE (e.`id_employee` = 7) AND (e.`passwd` = '$2y$10$d9XRpeZFEyMo2avs8utRmub78hGIARGWDf7c9F3Fdhl59q6fDfBjW') AND (e.`active` = 1) LIMIT 1

0.31/classes/Employee.php:408

SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1

0.31/classes/shop/Shop.php:1127

SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1

0.31/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE t.`id_authorization_role` FROM `ps_authorization_role` t LEFT JOIN ps_access j ON j.`id_authorization_role` = t.`id_authorization_role` WHERE `slug` = "ROLE_MOD_TAB_ADMINPERFORMANCE_READ" AND j.`id_profile` = "1" LIMIT 1

0.31/classes/Access.php:84

SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1

0.31/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'tusiekupuje.pl' OR su.domain_ssl = 'tusiekupuje.pl') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC

0.31/classes/shop/Shop.php:344

SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE `id_country` = 14

0.31/src/Adapter/EntityMapper.php:74

SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 99 LIMIT 1

0.31/classes/Tab.php:229

SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 76 LIMIT 1

0.31/classes/Tab.php:229

SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1

0.31/classes/shop/Shop.php:203

SELECT SQL_NO_CACHE `version` FROM `ps_module` WHERE `name` = 'gamification' LIMIT 1

0.21/modules/gamification/gamification.php:201

SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminperformance' LIMIT 1

0.2156/classes/Tab.php:202

SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1

0.21/classes/shop/ShopUrl.php:169

SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1

0.21/classes/Smarty/SmartyCustom.php:95

SELECT SQL_NO_CACHE `id_product_attribute` FROM `ps_product_attribute` LIMIT 1

0.213/classes/ObjectModel.php:1824

SELECT SQL_NO_CACHE * FROM `ps_hook_alias`

0.283/classes/Hook.php:226

SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1

0.21/src/Adapter/EntityMapper.php:67

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "welcome" LIMIT 1

0.21/classes/module/Module.php:2603

SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 53 AND `id_shop` = 1 LIMIT 1

0.21/classes/module/Module.php:2151

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "gamification" LIMIT 1

0.21/classes/module/Module.php:2603

SELECT SQL_NO_CACHE class_name FROM ps_tab WHERE id_tab = 1 LIMIT 1

0.21/classes/Tab.php:648

SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_mbo" LIMIT 1

0.20/classes/module/Module.php:2603

Doubles

3

SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl

[endriu107]

Na początek zmień PHP na 7.2

[Rymek]

Dobra .......

Dzięki za zaintereswoanie.

Mam winowajce.

Moduł "szukajki" zamulał do tego stopnia ze sie ładowała strona 20 sek.

Już jest idealnie....

Teraz mam do was prośbę jakiego używacie modułu do szybkiego wyszukiwania w sklepie? Szybki i nie zamulający ?

 

[krzysiek_web]

Domyślny z classic'a jest ok. 

[Rymek]

Powiedz mi jak go uruchomic ....bo ja nie mogę  

Ten z szablonu quick seraach bar  zamulił mi caly sklep....a jak chce domyslny wbudowany wlaczyc na szablonie nie moge.

 

Ok przenioslem moduł do NAV3 .i sie pojawił

Teraz wytlumaczcie laikowi jak zmienic np tlo paska szukania na szare bo go nie widac i jak usunac ta nieszczesliwa ikone lupki bo brzydka

Sklep stoi tymczasowo na 2light.pl

 

Edited November 14, 2020 by Rymek
Ogarniete (see edit history)

[endriu107]

@Rymek myślę że to już pytanie na inny wątek, trzymajmy się zasady że jeden temat to jedno zagadnienie.

[Rymek]

Ok .Przepraszam

 

Temat wolnego działania uważam za rozwiązany dziękuje.