cwms Posted August 13, 2017 Share Posted August 13, 2017 (edited) Bonjour, bonsoir, On a monté une boutique Prestashop 1.7.2 sur un serveur dédié cloud (ubuntu 16/8go de ram/SSD) et la base de données c'est du mariadb 10. On a importé 70 000 produits et quasiment terminé l'optimisation (varnish/mysql tuning etc). Tout est super rapide (front comme back) sauf sur l'affichage de la liste des produits du catalogue dans le backoffice où là, c'est plus que lent (40s). On a testé l'affichage du profiling debug, et il n'y a que cette query qui semble prendre 99% du temps d'affichage global. SELECT SQL_NO_CACHE SQL_CALC_FOUND_ROWS p.`id_product` AS `id_product`,p.`reference` AS `reference`,p.`price` AS `price`,p.`id_shop_default` AS `id_shop_default`,p.`is_virtual` AS `is_virtual`,pl.`name` AS `name`,pl.`link_rewrite` AS `link_rewrite`,sa.`active` AS `active`,shop.`name` AS `shopname`,image_shop.`id_image` AS `id_image`,cl.`name` AS `name_category`,0 AS `price_final`,pd.`nb_downloadable` AS `nb_downloadable`,sav.`quantity` AS `sav_quantity`,IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`FROM `ps_product` pLEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1)LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = p.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop_group = 1 AND sav.id_shop = 0 )JOIN `ps_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1)LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1)LEFT JOIN `ps_category` c ON (c.`id_category` = cl.`id_category`)LEFT JOIN `ps_shop` shop ON (shop.id_shop = 1)LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = 1)LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`)LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = p.`id_product`)WHERE (1 AND state = 1)ORDER BY `id_product` descLIMIT 0, 20; Donc c'est peut-être normal que ça soit si lent ? Et vous c'est quoi votre temps d'affichage de cette page pour combien de produits ? CWMS/. Edited August 14, 2017 by cwms (see edit history) 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