Palie Posted March 8, 2015 Share Posted March 8, 2015 Zdravim, muzete mi prosim vas nekdo poradit, jak vyresim loading u produktu, ktery jede i minutu? Koukam, ze mam First byte time strasne pomalej....v podstate mi to cele brzdi jen tohle. Mate nejake reseni? Diky predem za rady.http://webpagetest.org/result/150308_PH_BYX/1/details/ Link to comment Share on other sites More sharing options...
Kimi Posted March 8, 2015 Share Posted March 8, 2015 Skuste postupne vypinat moduly, ktore sa na detaile produktu spustaju. Moduly, ktore by to mohli byt najdete v Moduly > Pozice, potom ctrl+f product Dalsia moznost je zapnut profiling v subore config/defines.inc.php: define('_PS_DEBUG_PROFILING_', true); toto na koniec stranky prida ako dlho sa spustali hooky, ako dlho trvali databazove dotazy, atd pozor bude to viditelne na fronte takze to nerobte ked tam mate zakaznikov Link to comment Share on other sites More sharing options...
Palie Posted March 8, 2015 Author Share Posted March 8, 2015 (edited) Moduly jsem vyzkousel vypnout v noci a nebyl tam zadny rozdil jen par secund Load time: 88440 msYou'd better run your shop on a toaster Execution Load time (ms) config 112 constructor 0 init 12 checkAccess 0 setMedia 10 postProcess 0 initHeader 0 initContent 74697 initFooter 21 display 13587 Hook processing: 66982 ms / 63.94 Mb186 methods called in 36 modules Hook Processing actionProductListOverride 57.53 Mb in 64908 ms displayLeftColumn 1.50 Mb in 1384 ms displayHeader 3.08 Mb in 479 ms moduleRoutes 0.72 Mb in 70 ms displayTopColumn 0.05 Mb in 66 ms displayFooter 0.30 Mb in 21 ms displayTop 0.43 Mb in 21 ms displayNav 0.10 Mb in 15 ms displayBanner 0.05 Mb in 6 ms TopBanner 0.05 Mb in 3 ms underlist 0.05 Mb in 3 ms OverFooter 0.04 Mb in 3 ms footerTop 0.02 Mb in 2 ms displayProductListReviews 0.02 Mb in 1 ms displayProductListFunctionalButtons 0.01 Mb in 1 ms DisplayOverrideTemplate - Mb in 0 ms actionProductListModifier - Mb in 0 ms actionDispatcher - Mb in 0 ms actionFrontControllerSetMedia - Mb in 0 ms displayProductDeliveryTime - Mb in 0 ms displayProductPriceBlock - Mb in 0 ms Memory peak usage: 73.1 Mb Execution Memory (Mb) Total (Mb) config 4.43 4.4 constructor - 4.4 init 0.91 5.4 checkAccess - 5.4 setMedia 0.09 5.5 postProcess - 5.5 initHeader - 5.5 initContent 63.26 69.2 initFooter 0.31 69.3 display 2.85 73.1 Total cache size in Cache class: - Mb Smarty cache: enabled Smarty compilation: auto SQL Queries: 589 queries in 67714 ms Included files: 365 (4.80 Mb) Global vars : 0.52 Mb $_MODULES ≈ 357k $_LANG ≈ 128k $HTTP_SERVER_VARS ≈ 7k $_SERVER ≈ 7k $_MODULE ≈ 3k $HTTP_ENV_VARS ≈ 3k $_ENV ≈ 3k $HTTP_COOKIE ≈ 2k $_REQUEST ≈ 2k $_COOKIE ≈ 2k $HTTP_COOKIE_VARS ≈ 2k Stopwatch Doubles Tables stress ObjectModel instances Files included Stopwatch (with SQL_NO_CACHE) (total = 589) dekuji za dalsi rady. Edited March 8, 2015 by Palie (see edit history) Link to comment Share on other sites More sharing options...
Kimi Posted March 8, 2015 Share Posted March 8, 2015 vypnite moduly ktore pouzivaju actionProductListOverride, najdete to v tych poziciach modulov Link to comment Share on other sites More sharing options...
Palie Posted March 8, 2015 Author Share Posted March 8, 2015 po vypnuti a odinstalace Load time: 36228 msYou'd better run your shop on a toaster Execution Load time (ms) config 129 constructor 0 init 53 checkAccess 0 setMedia 15 postProcess 0 initHeader 0 initContent 34738 initFooter 68 display 1225 Hook processing: 570 ms / 4.79 Mb183 methods called in 35 modules Hook Processing displayHeader 2.70 Mb in 222 ms displayLeftColumn 0.33 Mb in 96 ms displayTop 0.41 Mb in 85 ms displayNav 0.14 Mb in 76 ms displayFooter 0.29 Mb in 68 ms moduleRoutes 0.71 Mb in 8 ms displayBanner 0.02 Mb in 5 ms TopBanner 0.03 Mb in 2 ms OverFooter 0.03 Mb in 2 ms footerTop 0.02 Mb in 2 ms displayTopColumn 0.04 Mb in 2 ms underlist 0.04 Mb in 1 ms displayProductListReviews 0.02 Mb in 1 ms displayProductListFunctionalButtons 0.01 Mb in 1 ms DisplayOverrideTemplate - Mb in 0 ms actionProductListModifier - Mb in 0 ms actionProductListOverride - Mb in 0 ms actionFrontControllerSetMedia - Mb in 0 ms actionDispatcher - Mb in 0 ms displayProductDeliveryTime - Mb in 0 ms displayProductPriceBlock - Mb in 0 ms Memory peak usage: 70.7 Mb Execution Memory (Mb) Total (Mb) config 4.45 4.5 constructor - 4.5 init 0.91 5.4 checkAccess - 5.4 setMedia 0.09 5.5 postProcess - 5.5 initHeader - 5.5 initContent 60.96 67.2 initFooter 0.31 67.2 display 2.78 70.7 Total cache size in Cache class: - Mb Smarty cache: enabled Smarty compilation: auto SQL Queries: 564 queries in 29911 ms Included files: 346 (4.29 Mb) Global vars : 0.42 Mb$_MODULES ≈ 257k $_LANG ≈ 128k $HTTP_SERVER_VARS ≈ 7k $_SERVER ≈ 7k $_MODULE ≈ 3k $HTTP_ENV_VARS ≈ 3k $_ENV ≈ 3k $HTTP_COOKIE ≈ 2k $_REQUEST ≈ 2k $_COOKIE ≈ 2k $HTTP_COOKIE_VARS ≈ 2k Stopwatch Doubles Tables stress ObjectModel instances Files included Stopwatch (with SQL_NO_CACHE) (total = 564) Link to comment Share on other sites More sharing options...
Palie Posted March 8, 2015 Author Share Posted March 8, 2015 cas nacitani http://www.webpagetest.org/result/150308_D0_K88/ Link to comment Share on other sites More sharing options...
Kimi Posted March 8, 2015 Share Posted March 8, 2015 pozrite sa nizsie v tom profiling vypise, ktore dotazy bezia tak dlho a kde Link to comment Share on other sites More sharing options...
Palie Posted March 8, 2015 Author Share Posted March 8, 2015 cely odkaz na stranku http://stag-henparty.co.uk/3-muzi Link to comment Share on other sites More sharing options...
Kimi Posted March 8, 2015 Share Posted March 8, 2015 u tych prvych 2 pomalych dotazov to vracia velmi vela riadkov pozrite sa do databazy, ci tam nemate tabulku s prilis vela riadkami Link to comment Share on other sites More sharing options...
Palie Posted March 8, 2015 Author Share Posted March 8, 2015 mam jich tam nekolik kolem 4 - 6tis a pak: ps_stock_available 123 367 ps_product_attribute 119 306 MyISAM utf8_general_ci 14 MiB - ps_product_attribute_combination 357 918 MyISAM utf8_general_ci 11,4 MiB - ps_product_attribute_image ps_product_attribute_shop 119 306 MyISAM utf8_general_ci 9,1 MiB co s tim mohu udelat? Link to comment Share on other sites More sharing options...
Kimi Posted March 8, 2015 Share Posted March 8, 2015 Pozeral som, ze vlastne u produktoch mate attributy miesto, den a mesiac. To vytvara cca 3000 kombinacii len pre jeden produkt. To je korenom celeho problemu. Ak vam ten vyber attributu neovplyvnuje sklad/cenu/obrazok, tak by som ten vyber neriesil cez atributy ale prisposobenie (v editaci produktu karta Prispusobeni), kde si mozte navolit kolko chcete policok a ako sa budu volat. Atribut s miestom akcie by mohol ostat pretoze tam treba vyuzivat preddefnovane hodnoty. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now