Jump to content

Tienda Prestashop 1.6.0.11 muuuy lenta.

alviro

By alviro
in Discusión general

 Share

Recommended Posts

alviro Newbie

alviro

Posted
Posted

Buenos días,

 

Tengo una tienda en prestashop aun en producción, tenemos ya mas de 3000 productos introducidos, cuando funcionabamos con la versión 1.5 la tienda andaba bastante ágil, desde que actualizamos a la 1.6 la cosa cambio y va muy lenta a veces desesperante en el backoffice. Se hace eterno, casi imposible, el introducir un producto nuevo.

Os pregunto para ver si podéis darme algún tipo de solución ya que en este punto me encuentro desesperado.

La tienda es laboutiquedelanavaja.es, os puedo pasar el pass por si podéis echarle un vistazo.

He hablado con los administradores de mi hosting y me dicen que el tema de la lentitud se debe a un mala optimización del rendimiento de la tienda y no a un problema en el alojamiento.

He activado el PS_DEBUG_PROFILING en la tienda para ver tiempos de carga e intuir que esta pasando. 

Si pusierais echarme una mano estaría muy agradecido.

 

 

Stopwatch (with SQL_NO_CACHE) (total = 44) Query Time (ms) Rows Filesort Group By Location 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`) 12.5 555     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Configuration.php:134
from /classes/Configuration.php:170
from /classes/Configuration.php:226
from /classes/shop/Shop.php:367
from /config/config.inc.php:97
from /administrator/index.php:34
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
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 != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position` 2.7 74 Yes Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:346
from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:414
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /administrator/index.php:54
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
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 != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position` 1.8 98 Yes Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:346
from /tools/profiling/Hook.php:50
from /classes/controller/AdminController.php:2438
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
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 != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position` 1.7 98 Yes Yes in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:346
from /classes/Hook.php:416
from /tools/profiling/Hook.php:60
from /classes/controller/AdminController.php:2438
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
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.6 0     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:131
from /classes/Hook.php:420
from /tools/profiling/Hook.php:60
from /classes/controller/AdminController.php:2438
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
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` = 3)
WHERE 1
ORDER BY t.`position` ASC 1.4 103 Yes   in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:256
from /classes/Profile.php:126
from /classes/Profile.php:108
from /classes/controller/AdminController.php:370
from /controllers/admin/AdminPerformanceController.php:34
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:367
from /administrator/index.php:54
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 1.3 111 Yes   in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Dispatcher.php:462
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /administrator/index.php:54
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` LIKE "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 1 286     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:1013
from /classes/Configuration.php:175
from /classes/Configuration.php:226
from /classes/shop/Shop.php:367
from /config/config.inc.php:97
from /administrator/index.php:34
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 = 3
LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1
WHERE (a.id_country = 6)
LIMIT 1 0.9 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:125
from /administrator/index.php:34
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.9 7     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Language.php:712
from /config/config.inc.php:122
from /administrator/index.php:34
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
LIMIT 1 0.9 2108     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:1486
from /classes/Combination.php:272
from /controllers/admin/AdminPerformanceController.php:218
from /controllers/admin/AdminPerformanceController.php:609
from /controllers/admin/AdminPerformanceController.php:634
from /tools/profiling/Controller.php:171
from /classes/Dispatcher.php:374
from /administrator/index.php:54
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 = 'www.laboutiquedelanavaja.com' OR su.domain_ssl = 'www.laboutiquedelanavaja.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC 0.8 1 Yes   in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:329
from /config/config.inc.php:97
from /administrator/index.php:34
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.8 1 Yes   in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:641
from /classes/shop/Shop.php:689
from /classes/Configuration.php:223
from /classes/shop/Shop.php:367
from /config/config.inc.php:97
from /administrator/index.php:34
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 = 1)
LIMIT 1 0.7 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/Employee.php:144
from /config/config.inc.php:166
from /administrator/index.php:34
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m 0.7 98     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:220
from /modules/themeconfigurator/themeconfigurator.php:46
from /classes/module/Module.php:1044
from /classes/Hook.php:492
from /tools/profiling/Hook.php:60
from /classes/controller/AdminController.php:2438
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
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` = 3)
ORDER BY `name` ASC 0.7 5 Yes   in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/QuickAccess.php:65
from /classes/controller/AdminController.php:1591
from /tools/profiling/Controller.php:166
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE t.`class_name`, t.`module`
FROM `ps_tab` t
WHERE t.`module` IS NOT NULL AND t.`module` != "" 0.6 103     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:232
from /classes/Translate.php:49
from /classes/controller/AdminController.php:2366
from /classes/controller/AdminController.php:334
from /controllers/admin/AdminPerformanceController.php:34
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:367
from /administrator/index.php:54
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab` 0.6 103     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:287
from /classes/Tab.php:365
from /classes/Dispatcher.php:307
from /administrator/index.php:54
SELECT SQL_NO_CACHE *
FROM `ps_tab` a
LEFT JOIN `ps_tab_lang` `b` ON a.id_tab = b.id_tab AND b.id_lang = 3
WHERE (a.id_tab = 78)
LIMIT 1 0.5 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/Tab.php:366
from /classes/Dispatcher.php:307
from /administrator/index.php:54
SELECT SQL_NO_CACHE * FROM ps_memcached_servers 0.5 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/cache/CacheMemcache.php:200
from /classes/cache/CacheMemcache.php:100
from /classes/cache/CacheMemcache.php:45
from /classes/cache/Cache.php:131
from /classes/db/Db.php:503
from /classes/shop/Shop.php:329
from /config/config.inc.php:97
from /administrator/index.php:34
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` 0.5 86     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Hook.php:183
from /classes/Hook.php:202
from /classes/Hook.php:373
from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:414
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /administrator/index.php:54
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 0.4 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/Shop.php:199
from /classes/shop/Shop.php:133
from /classes/shop/Shop.php:394
from /config/config.inc.php:97
from /administrator/index.php:34
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.4 7     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Language.php:825
from /classes/Language.php:925
from /classes/Dispatcher.php:398
from /classes/Dispatcher.php:221
from /classes/Dispatcher.php:193
from /administrator/index.php:54
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.4 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/Currency.php:103
from /classes/controller/AdminController.php:386
from /controllers/admin/AdminPerformanceController.php:34
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:367
from /administrator/index.php:54
UPDATE `ps_employee`
SET `last_connection_date` = CURRENT_DATE()
WHERE `id_employee` = 1 AND `last_connection_date`< CURRENT_DATE() 0.4 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Employee.php:460
from /classes/controller/AdminController.php:2445
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.id_shop = 1)
LIMIT 1 0.3 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:131
from /classes/shop/Shop.php:394
from /config/config.inc.php:97
from /administrator/index.php:34
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.id_theme = 8)
LIMIT 1 0.3 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:98
from /administrator/index.php:34
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1) 0.3 18     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:1931
from /classes/Hook.php:469
from /tools/profiling/Hook.php:60
from /classes/controller/AdminController.php:2438
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE COUNT(*) n
FROM `ps_module_shop`
WHERE id_module=85 AND id_shop IN (1)
GROUP BY id_module
HAVING n=1 LIMIT 1 0.3 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:1995
from /classes/controller/AdminController.php:1672
from /tools/profiling/Controller.php:166
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.id_shop_group = 1)
LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/controller/AdminController.php:1723
from /tools/profiling/Controller.php:166
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE `id_employee`
FROM `ps_employee`
WHERE `id_employee` = 1
AND `passwd` = '95b321018e63ff1c0841a465c2a148cf'
AND active = 1 LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Employee.php:299
from /classes/Employee.php:342
from /classes/controller/AdminController.php:2454
from /classes/controller/AdminController.php:384
from /controllers/admin/AdminPerformanceController.php:34
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:367
from /administrator/index.php:54
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/shop/ShopUrl.php:163
from /classes/shop/ShopUrl.php:177
from /classes/Tools.php:202
from /classes/Link.php:52
from /config/config.inc.php:215
from /administrator/index.php:34
SELECT SQL_NO_CACHE `id_parent`
FROM `ps_tab`
WHERE LOWER(class_name) = 'adminperformance' LIMIT 1 0.2 103     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:188
from /classes/controller/AdminController.php:1624
from /tools/profiling/Controller.php:166
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_group` LIMIT 1 0.2 3     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Group.php:225
from /controllers/admin/AdminPerformanceController.php:258
from /controllers/admin/AdminPerformanceController.php:609
from /controllers/admin/AdminPerformanceController.php:634
from /tools/profiling/Controller.php:171
from /classes/Dispatcher.php:374
from /administrator/index.php:54
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 = 6)
LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/controller/AdminController.php:2521
from /classes/controller/AdminController.php:384
from /controllers/admin/AdminPerformanceController.php:34
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:367
from /administrator/index.php:54
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 = 3)
LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:228
from /tools/profiling/ObjectModel.php:37
from /classes/Language.php:90
from /config/config.inc.php:178
from /administrator/index.php:34
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` = 3)
WHERE t.`id_tab` = 78 LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:213
from /classes/Tab.php:485
from /classes/controller/AdminController.php:427
from /classes/controller/AdminController.php:2448
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "vatnumber" LIMIT 1 0.2 0     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/module/Module.php:2291
from /classes/module/Module.php:1981
from /classes/helper/HelperForm.php:237
from /classes/helper/HelperForm.php:65
from /classes/controller/AdminController.php:2214
from /controllers/admin/AdminPerformanceController.php:625
from /controllers/admin/AdminPerformanceController.php:634
from /tools/profiling/Controller.php:171
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE * FROM `ps_country_lang`
WHERE `id_country` = 6 0.2 7     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:235
from /tools/profiling/ObjectModel.php:37
from /classes/controller/AdminController.php:2521
from /classes/controller/AdminController.php:384
from /controllers/admin/AdminPerformanceController.php:34
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:367
from /administrator/index.php:54
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` = 3)
WHERE t.`id_tab` = 17 LIMIT 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:213
from /classes/Tab.php:485
from /classes/Tab.php:488
from /classes/controller/AdminController.php:427
from /classes/controller/AdminController.php:2448
from /tools/profiling/Controller.php:142
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:1326
from /classes/Employee.php:150
from /config/config.inc.php:166
from /administrator/index.php:34
SELECT SQL_NO_CACHE * FROM ps_memcached_servers 0.2 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/cache/CacheMemcache.php:200
from /controllers/admin/AdminPerformanceController.php:601
from /controllers/admin/AdminPerformanceController.php:616
from /controllers/admin/AdminPerformanceController.php:634
from /tools/profiling/Controller.php:171
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
LIMIT 1 0.2 2108     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/ObjectModel.php:1486
from /classes/Combination.php:272
from /controllers/admin/AdminPerformanceController.php:232
from /controllers/admin/AdminPerformanceController.php:609
from /controllers/admin/AdminPerformanceController.php:634
from /tools/profiling/Controller.php:171
from /classes/Dispatcher.php:374
from /administrator/index.php:54
SELECT SQL_NO_CACHE class_name FROM ps_tab WHERE id_tab = 1 LIMIT 1 0.1 1     in /var/www/vhosts/laboutiquedelanavaja.com/httpdocs/classes/Tab.php:535
from /classes/controller/AdminController.php:1728
from /tools/profiling/Controller.php:166
from /classes/Dispatcher.php:374
from /administrator/index.php:54
Doubles (IDs replaced by "XX") (total = 4) 2 SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` 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 != "displayPayment") AND (hm.id_shop = XX) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` 2 SELECT * FROM ps_memcached_servers 2 SELECT `id_product_attribute` FROM `ps_product_attribute` LIMIT XX 2 SELECT * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) WHERE t.`id_tab` = XX LIMIT XX
Tables stress 8 tab 5 hook 5 module 4 module_shop 4 shop 4 shop_url 4 tab_lang 3 lang_shop 3 hook_module 3 lang 2 theme 2 hook_alias 2 product_attribute 2 configuration 2 country 2 shop_group 2 country_lang 2 country_shop 2 employee 2 memcached_servers 2 employee_shop 1 quick_access 1 quick_access_lang 1 group 1 hook_module_exceptions 1 meta 1 meta_lang 1 configuration_lang 1 currency 1 currency_shop
ObjectModel instances Name Instance Source Language 2
config/config.inc.php [178]
classes/controller/AdminController.php [1999]
Shop 2
config/config.inc.php [97]
classes/controller/AdminController.php [1736]
Country 2
config/config.inc.php [125]
classes/controller/AdminController.php [2521]
ShopGroup 1
classes/controller/AdminController.php [1723]
Currency 1
classes/controller/AdminController.php [386]
Employee 1
config/config.inc.php [166]
Theme 1
config/config.inc.php [98]
Tab 1
classes/Dispatcher.php [307]
Included files # Filename 1 administrator/index.php 2 administrator/../config/config.inc.php 3 config/config.inc.php 4 config/defines.inc.php 5 config/settings.inc.php 6 config/autoload.php 7 config/alias.php 8 classes/PrestaShopAutoload.php 9 cache/class_index.php 10 tools/profiling/Controller.php 11 classes/controller/Controller.php 12 tools/profiling/ObjectModel.php 13 classes/ObjectModel.php 14 tools/profiling/Hook.php 15 classes/Hook.php 16 tools/profiling/Db.php 17 classes/db/Db.php 18 tools/profiling/Tools.php 19 classes/Tools.php 20 classes/Context.php 21 classes/shop/Shop.php 22 config/db_slave_server.inc.php 23 classes/db/DbPDO.php 24 classes/cache/Cache.php 25 classes/cache/CacheMemcache.php 26 classes/Configuration.php 27 classes/Validate.php 28 classes/db/DbQuery.php 29 classes/Theme.php 30 config/defines_uri.inc.php 31 tools/htmlpurifier/HTMLPurifier.standalone.php 32 classes/Language.php 33 classes/Country.php 34 classes/PrestaShopCollection.php 35 classes/Cookie.php 36 classes/Rijndael.php 37 classes/Employee.php 38 classes/Link.php 39 classes/shop/ShopUrl.php 40 config/smarty.config.inc.php 41 tools/smarty/Smarty.class.php 42 tools/smarty/sysplugins/smarty_internal_data.php 43 tools/smarty/sysplugins/smarty_internal_templatebase.php 44 tools/smarty/sysplugins/smarty_internal_template.php 45 tools/smarty/sysplugins/smarty_resource.php 46 tools/smarty/sysplugins/smarty_internal_resource_file.php 47 tools/smarty/sysplugins/smarty_cacheresource.php 48 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 49 config/smartyadmin.config.inc.php 50 administrator/functions.php 51 ./images.inc.php 52 classes/Dispatcher.php 53 classes/Group.php 54 tools/mobile_Detect/Mobile_Detect.php 55 classes/Tab.php 56 controllers/admin/AdminPerformanceController.php 57 classes/controller/AdminController.php 58 classes/Translate.php 59 translations/es/admin.php 60 classes/Profile.php 61 classes/Currency.php 62 classes/module/Module.php 63 modules/themeconfigurator/themeconfigurator.php 64 modules/themeconfigurator/translations/es.php 65 modules/minicslider/minicslider.php 66 modules/minicslider/es.php 67 modules/ganalytics/ganalytics.php 68 modules/ganalytics/translations/es.php 69 modules/ganalytics/es.php 70 cache/smarty/compile/63/8e/24/638e248907fb9ea1e13ef6419958b1e07b8b7aa3.file.login_addons.tpl.php 71 classes/Media.php 72 modules/dashactivity/dashactivity.php 73 modules/dashactivity/translations/es.php 74 modules/dashtrends/dashtrends.php 75 modules/dashtrends/translations/es.php 76 modules/dashgoals/dashgoals.php 77 modules/dashgoals/translations/es.php 78 classes/QuickAccess.php 79 modules/autoupgrade/autoupgrade.php 80 modules/autoupgrade/translations/es.php 81 modules/autoupgrade/es.php 82 classes/helper/Helper.php 83 classes/shop/ShopGroup.php 84 classes/Combination.php 85 classes/Feature.php 86 classes/helper/HelperForm.php 87 cache/smarty/compile/03/03/a9/0303a9f6ea8454bb4057cd42bd7bac8cc5f84d2a.file.form.tpl.php 88 tools/smarty/plugins/function.counter.php 89 cache/smarty/compile/02/4a/66/024a66791c9c6fa58aede5a30fcaff8036a1d404.file.modal.tpl.php 90 cache/smarty/compile/43/73/71/437371d94b6999d2bbe1d1b5655d348e3c065e85.file.content.tpl.php 91 cache/smarty/compile/c2/b6/b5/c2b6b5deea76ca6494e24abd8f99f79c96ca377a.file.page_header_toolbar.tpl.php 92 cache/smarty/compile/77/18/fb/7718fb026a7c42bc30526b0ee4e10bb420de1468.file.modal.tpl.php 93 cache/smarty/compile/d3/d5/9b/d3d59b8a8a085f3babac9426edb121ac4c1c378a.file.header.tpl.php 94 cache/smarty/compile/41/8e/81/418e8124cb0ce21bd871477ec5dd4f3496050279.file.javascript.tpl.php 95 tools/smarty/plugins/modifier.replace.php 96 cache/smarty/compile/67/dc/6e/67dc6e50ac0634297a7481d0ab4fd066dab0cadc.file.nav.tpl.php 97 cache/smarty/compile/37/9b/65/379b65589be4cc10cc0f66649d0778d647609d34.file.search_form.tpl.php 98 cache/smarty/compile/0f/38/de/0f38deca04c6885f7d5f15790f1be0204cabcfb1.file.footer.tpl.php 99 cache/smarty/compile/66/68/f2/6668f2cb5cdf450942bf0b99bfe5098cf7a8bbf0.file.layout.tpl.php

 

Link to comment
Share on other sites
EcoLògic Newbie

EcoLògic

Posted
Posted

Yo empecé probando el 1.6 en modo local, y modificar el precio de un producto tardaba 24 segundos.

Cambié la configuración según me aconsejó otro usuario y pasé a los 12 segundos, lo cual es inviable para instalarselo a mis clientes.

Ahora estoy probando con la versión Cloud y aquí tarda 5 segundos y el resto funciona muy bien.


Estuve consultando en otros foros y probé una docena de posibles soluciones, pero no conseguí nada viable.

(estoy usando windows 8, con un dual core a 2.1 Ghz, con 4 Gb de RAM)

Si las limitaciones de la versión Cloud me impiden poner Prestashop a mis clientes tendré que buscar otra herramienta...

Link to comment
Share on other sites
alviro Newbie

alviro

Posted
  • Author
Posted

Hola de nuevo y buenas tardes,

Enrique estoy de acuerdo contigo en que gran parte del buen rendimiento de una tienda online pasa por el tipo de alojamiento así como su configuración optima para prestashop.

Yo ya he hablado en varias ocasiones con mi proveedor de alojamiento web y siempre me han dado la misma respuesta, que mi tienda va lenta por que la tengo mal configurada. He propuesto también el cambio a un tipo de hosting mas exclusivo u orientado a prestashop pero me dicen que no me aseguran que vaya a funcionarme mas rápido.

 

Lo que si es verdad es como bien dice EcoLógic no se le puede presentar a un cliente una tienda en la que la navegación por ella se hace irritante, esta claro que eso repercutiría en las ventas negativamente.

 

Yo ya he probado a limpiar la base de datos de conexiones así como a optimizarla. He configurado la tienda en las opciones de rendimiento como aconsejáis en este foro y en los manuales de prestashop. He revertido todos los cambios estéticos que hice en la plantilla que además es la que esta por defecto. He eliminado los módulos que instale por si alguno de ellos fuera el culpable y nada.

 

Si he notado que lo que realmente va muy lento en le backoffice es cuando accedo al apartado de modulos por eso pienso que algún módulo puede tener la culpa, modulo de los que vienen preinstalados por que como ya apunté los que yo había instalado los elimine.

 

Bueno, seguiremos probando opciones a ver si damos con el problema.

Muchas gracias por vuestras respuestas.

Link to comment
Share on other sites
alviro Newbie

alviro

Posted
  • Author
Posted

Buenas Noches,

 

Acabo de escribir a mi proveedor de alojamiento solicitando si hay alguna manera de que me optimicen el servidor para mejorar el funcionamiento de mi tienda, sobre todo el backoffice.

Os adjunto lo que me han contestado:

--------------------------------------------------------------------------------------------------------------------------

Buenas tardes

El hecho que el FTP le vaya lento, no es algo que tenga tanto que ver con el servidor sino probablemente con su conexión internet, puede hacernos llegar una traza desde su conexión hacia el servidor? (inicio > ejecutar > cmd,
teclee
tracert  laboutiquedelanavaja.com
y haganos llegar el resultado)

Haciendo la prueba con https://developers.google.com/speed/pagespeed/insights/, la respuesta no es mala ni mucho menos, pues se obtiene un 97/100 en la version ordenador y la respuesta del servidor es adcuado con el tiempo que indica goolge (0,2 segundo), dicho eso, hay varios factores que no han sido optimizado :
- Eliminar el JavaScript que bloquea la visualización y el CSS del contenido de la mitad superior de la página
- Habilitar compresión en el htaccess

Segun webspeed, su web carga en 763ms : http://tools.pingdom.com/fpt/#!/dvDiJk/laboutiquedelanavaja.com

Quedamos a la espera de su traza para comprobar si el problema real no esta relacionado con su conexión internet.

Reciba un cordial saludo

-------------------------------------------------------------------------------------------------------------------------------------------

 Esta es la traza que yo les he enviado:

 

Traza a la dirección laboutiquedelanavaja.com [193.42.143.45]
sobre un máximo de 30 saltos:

  1    <1 ms    <1 ms    <1 ms  192.168.1.1
  2    24 ms    24 ms    24 ms  128.Red-80-58-67.staticIP.rima-tde.net [80.58.67
.128]
  3    29 ms    31 ms    31 ms  129.Red-80-58-94.staticIP.rima-tde.net [80.58.94
.129]
  4    30 ms    31 ms    31 ms  69.Red-80-58-76.staticIP.rima-tde.net [80.58.76.
69]
  5    27 ms    29 ms    27 ms  So-5-0-0-0-grtmadde2.red.telefonica-wholesale.ne
t [84.16.9.165]
  6    49 ms    62 ms    49 ms  Xe-2-0-2-0-grtparix1.red.telefonica-wholesale.ne
t [94.142.117.174]
  7    48 ms    50 ms    51 ms  213.140.52.50
  8    50 ms    55 ms    51 ms  be2337.rcr21.par05.atlas.cogentco.com [130.117.1
.1]
  9    52 ms    51 ms    52 ms  be2424.ccr41.par01.atlas.cogentco.com [130.117.2
.237]
 10    56 ms    55 ms    52 ms  be2044.agr21.par01.atlas.cogentco.com [130.117.5
1.78]
 11    54 ms    58 ms    54 ms  te0-0-1-0.rcr11.rhe01.atlas.cogentco.com [154.54
.36.22]
 12    58 ms    61 ms    57 ms  ikoula.demarc.cogentco.com [149.6.104.2]
 13     *       58 ms    62 ms  po2.vss1.ikdc1.ikoula.com [213.246.32.117]
 14    58 ms    57 ms    57 ms  l013.configbox.com [193.42.143.45]

Traza completa.

------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

Su respuesta a la traza:

 

Vemos que los tiempos son algo altos en la propia red de telefonica en los primeros pasos, y llega con tiempos algo altos también al servidor :

Link to comment
Share on other sites
  • 3 weeks later...

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...