Vitesse

[JOE DP PNEUS]

Bonjour,
 

Nous rencontrons un grave problème de vitesse sur notre site possédant 60000 produits.

notre configuration:

Linux ns3431900.ip-87-98-219.eu 3.14.32-xxxx-grs-ipv6-64 #5 SMP Wed Sep 9 17:24:34 CEST 2015 x86_64 Intel® Core i7 CPU 950 @ 3.07GHz GenuineIntel GNU/Linux
 

apache, 
APACHE2_OPTS="-D DEFAULT_VHOST -D INFO -D SSL -D SSL_DEFAULT_VHOST -D LANGUAGE -D PHP5 -D SECURITY -D FCGID"

mysql, 
cdn, 
Memcached par PHP::Memcache, 
compression js css, 

nginx pour les images
 

Malgré cela le front office ouvre les page en 10 a 15 secondes par contre aucun problème côté backoffice
 

Quelles recommandations avez vous a nous faire pour que nous puissions avoir un site accessible.

www.joedppneus.fr

[Oron]

Bonjour

 

Merci de poster dans le bon forum avant de créer un topic lisez le thème du forum

Topic déplacé dans Utilisation configuration et difficultés

 

Veuillez aussi modifier votre sujet Vitesse veut rien dire nous ne sommes pas sur un site  de formule 1

Edited January 18, 2016 by Oron (see edit history)

[JOE DP PNEUS]

Que voulez vous dire par désactiver les surcharges. pour les modules non prestashop oui sauf storecommander.

[JOE DP PNEUS]

Tout est coché et tout est compressé

 

"Smart cache" pour les feuilles de style

Oui Non

 

"Smart cache" pour le code JavaScript

Oui Non

 

Réduction du code HTML

Oui Non

 

Compression du JavaScript dans le code HTML

Oui Non

 

Déplacer le code JavaScript à la fin

Oui Non

 

Optimisation Apache

Oui Non

 

 

Mais rien ne fait ....

 

 

 

[JOE DP PNEUS]

J'ai bien essayé mais c'est pas mieux toujours aussi lent voir pire

[JOE DP PNEUS]

 

 

Load Time 4366 ms - You'd better run your shop on a toaster Querying Time 9 ms Queries 8 Memory Peak Usage 44.4 Mb Included Files 214 files - 4.38 Mb PrestaShop Cache 0.64 Mb Global vars 2.07 Mb

PrestaShop Version 1.6.1.2 PHP Version 5.6.17-pl0-gentoo (OK) MySQL Version 5.6.27 (OK) Memory Limit 128M Max Execution Time 30s Smarty Cache enabled Smarty Compilation never recompile

  Time Cumulated Time Memory Usage Memory Peak Usage config 86 ms 86 ms 12.51 Mb 12.60 Mb __construct 0 ms 86 ms - Mb 12.60 Mb init 3054 ms 3140 ms 23.48 Mb 43.79 Mb checkAccess 0 ms 3140 ms - Mb 43.79 Mb setMedia 1220 ms 4360 ms 0.60 Mb 44.44 Mb postProcess 0 ms 4360 ms - Mb 44.44 Mb initHeader 2 ms 4362 ms 0.31 Mb 44.44 Mb initContent 3 ms 4365 ms 0.23 Mb 44.44 Mb initFooter 1 ms 4366 ms 0.04 Mb 44.44 Mb

Hook Time Memory Usage __construct 70 ms 7.25 Mb hookdisplayBackOfficeHeader 3 ms - Mb hookactionAdminControllerSetMedia 1 ms - Mb hookbackofficeheader 0 ms - Mb 4 hooks 74 ms 7.25 Mb

Module Time Memory Usage envoimoinscher 17 ms 2.50 Mb nostotagging 16 ms 1.50 Mb paypal 9 ms 0.75 Mb fianetsceau 7 ms 0.75 Mb mondialrelay 7 ms 0.75 Mb gamification 5 ms - Mb dashgoals 4 ms 0.25 Mb dashactivity 3 ms 0.25 Mb themeconfigurator 2 ms 0.25 Mb ganalytics 2 ms 0.25 Mb dashtrends 2 ms - Mb 11 modules 74 ms 7.25 Mb

1. Stopwatch SQL
2. Doubles
3. Tables stress
4. ObjectModel instances
5. Included Files

Stopwatch SQL - 8 queries 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_shopFROM `sp31rc3en_configuration` cLEFT JOIN `sp31rc3en_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)

4.2 829     /classes/Configuration.php:148

SELECT SQL_NO_CACHE `id_hook`, `name`FROM `sp31rc3en_hook`UNIONSELECT `id_hook`, ha.`alias` as nameFROM `sp31rc3en_hook_alias` haINNER JOIN `sp31rc3en_hook` h ON ha.name = h.name

1.8 0     /classes/Hook.php:131

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

1.1 482     /classes/module/Module.php:2141

SELECT SQL_NO_CACHE *FROM `sp31rc3en_access` aLEFT JOIN `sp31rc3en_tab` t ON t.id_tab = a.id_tabWHERE `id_profile` = 0

0.4 1     /classes/Profile.php:143

SELECT SQL_NO_CACHE id_tab, class_name FROM `sp31rc3en_tab`

0.4 151     /classes/Tab.php:296

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

0.3 1     /classes/SmartyCustom.php:95

UPDATE `sp31rc3en_employee`SET `last_connection_date` = CURRENT_DATE()WHERE `id_employee` = 0 AND `last_connection_date`< CURRENT_DATE()

0.3 1     /classes/Employee.php:494

SELECT SQL_NO_CACHE * FROM sp31rc3en_memcached_servers

0.2 1     /classes/cache/CacheMemcache.php:253

Doubles

Tables stress 2 tab 2 hook 1 hook_alias 1 hook_module_exceptions 1 smarty_last_flush 1 access 1 configuration 1 configuration_lang 1 memcached_servers

ObjectModel instances Name Instances Source Shop 2 /config/config.inc.php [90]
/classes/controller/AdminController.php [1926] Tab 1 /classes/Dispatcher.php [307] Currency 1 /classes/controller/AdminController.php [494] Language 1 /config/config.inc.php [174] Employee 1 /config/config.inc.php [158] Theme 1 /config/config.inc.php [91] Country 1 /config/config.inc.php [118]

Included Files # Filename 1 /backoffice/index.php 2 /config/config.inc.php 3 /config/defines.inc.php 4 /config/settings.inc.php 5 /config/autoload.php 6 /config/alias.php 7 /classes/PrestaShopAutoload.php 8 /cache/class_index.php 9 /config/bootstrap.php 10 /Core/Business/Core_Business_ContainerBuilder.php 11 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php 12 /Adapter/Adapter_ServiceLocator.php 13 /classes/controller/Controller.php 14 /classes/ObjectModel.php 15 /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php 16 /classes/db/Db.php 17 /classes/Tools.php 18 /classes/Context.php 19 /classes/shop/Shop.php 20 /classes/db/DbPDO.php 21 /classes/cache/Cache.php 22 /classes/cache/CacheMemcache.php 23 /config/db_slave_server.inc.php 24 /classes/Configuration.php 25 /classes/Validate.php 26 /Adapter/Adapter_EntityMapper.php 27 /classes/db/DbQuery.php 28 /classes/Theme.php 29 /config/defines_uri.inc.php 30 /tools/htmlpurifier/HTMLPurifier.standalone.php 31 /classes/Language.php 32 /classes/Country.php 33 /classes/PrestaShopCollection.php 34 /classes/Cookie.php 35 /classes/Rijndael.php 36 /classes/Employee.php 37 /classes/Link.php 38 /classes/shop/ShopUrl.php 39 /config/smarty.config.inc.php 40 /tools/smarty/Smarty.class.php 41 /tools/smarty/sysplugins/smarty_internal_data.php 42 /tools/smarty/sysplugins/smarty_internal_templatebase.php 43 /tools/smarty/sysplugins/smarty_internal_template.php 44 /tools/smarty/sysplugins/smarty_resource.php 45 /tools/smarty/sysplugins/smarty_internal_resource_file.php 46 /tools/smarty/sysplugins/smarty_cacheresource.php 47 /tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 48 /classes/SmartyCustom.php 49 /classes/SmartyCacheResourceMysql.php 50 /tools/smarty/sysplugins/smarty_cacheresource_custom.php 51 /config/smartyadmin.config.inc.php 52 /backoffice/functions.php 53 /images.inc.php 54 /classes/Dispatcher.php 55 /classes/Hook.php 56 /classes/Group.php 57 /tools/mobile_Detect/Mobile_Detect.php 58 /classes/Tab.php 59 /controllers/admin/AdminDashboardController.php 60 /classes/controller/AdminController.php 61 /classes/Translate.php 62 /translations/fr/admin.php 63 /classes/Profile.php 64 /classes/Currency.php 65 /classes/module/Module.php 66 /modules/themeconfigurator/themeconfigurator.php 67 /modules/themeconfigurator/translations/fr.php 68 /modules/gamification/gamification.php 69 /modules/gamification/classes/Badge.php 70 /modules/gamification/classes/Advice.php 71 /modules/gamification/classes/Condition.php 72 /modules/gamification/classes/GamificationTools.php 73 /modules/gamification/translations/fr.php 74 /modules/gamification/fr.php 75 /classes/Media.php 76 /modules/paypal/paypal.php 77 /modules/paypal/api/paypal_lib.php 78 /modules/paypal/api/paypal_connect.php 79 /modules/paypal/paypal_logos.php 80 /modules/paypal/paypal_orders.php 81 /modules/paypal/paypal_tools.php 82 /modules/paypal/paypal_login/paypal_login.php 83 /modules/paypal/paypal_login/PayPalLoginUser.php 84 /modules/paypal/classes/PaypalCapture.php 85 /classes/PaymentModule.php 86 /modules/paypal/fr.php 87 /modules/ganalytics/ganalytics.php 88 /modules/ganalytics/translations/fr.php 89 /modules/ganalytics/fr.php 90 /modules/mondialrelay/mondialrelay.php 91 /modules/mondialrelay/classes/MRTools.php 92 /modules/mondialrelay/fr.php 93 /modules/mondialrelay/backward_compatibility/backward.php 94 /modules/mondialrelay/backward_compatibility/Display.php 95 /classes/controller/FrontController.php 96 /modules/envoimoinscher/envoimoinscher.php 97 /classes/module/CarrierModule.php 98 /modules/envoimoinscher/includes/EnvoimoinscherModel.php 99 /modules/envoimoinscher/includes/EnvoimoinscherHelper.php 100 /modules/envoimoinscher/includes/EnvoimoinscherOrder.php 101 /modules/envoimoinscher/translations/fr.php 102 /modules/nostotagging/nostotagging.php 103 /modules/nostotagging/libs/nosto/php-sdk/src/config.inc.php 104 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/account/NostoAccountInterface.php 105 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/account/NostoAccountMetaDataBillingDetailsInterface.php 106 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/account/NostoAccountMetaDataIframeInterface.php 107 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/account/NostoAccountMetaDataInterface.php 108 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/account/NostoAccountMetaDataOwnerInterface.php 109 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/order/NostoOrderBuyerInterface.php 110 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/order/NostoOrderInterface.php 111 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/order/NostoOrderPurchasedItemInterface.php 112 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/order/NostoOrderStatusInterface.php 113 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/NostoOAuthClientMetaDataInterface.php 114 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/NostoProductInterface.php 115 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/NostoExportCollectionInterface.php 116 /modules/nostotagging/libs/nosto/php-sdk/src/interfaces/NostoValidatableInterface.php 117 /modules/nostotagging/libs/nosto/php-sdk/src/classes/http/NostoHttpRequest.php 118 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoObject.php 119 /modules/nostotagging/libs/nosto/php-sdk/src/classes/api/NostoApiRequest.php 120 /modules/nostotagging/libs/nosto/php-sdk/src/classes/api/NostoApiToken.php 121 /modules/nostotagging/libs/nosto/php-sdk/src/classes/collection/NostoCollection.php 122 /modules/nostotagging/libs/nosto/php-sdk/src/classes/collection/NostoProductCollection.php 123 /modules/nostotagging/libs/nosto/php-sdk/src/classes/collection/NostoOrderCollection.php 124 /modules/nostotagging/libs/nosto/php-sdk/src/classes/exception/NostoException.php 125 /modules/nostotagging/libs/nosto/php-sdk/src/classes/exception/NostoHttpException.php 126 /modules/nostotagging/libs/nosto/php-sdk/src/classes/export/NostoExporter.php 127 /modules/nostotagging/libs/nosto/php-sdk/src/classes/export/NostoExportProductCollection.php 128 /modules/nostotagging/libs/nosto/php-sdk/src/classes/export/NostoExportOrderCollection.php 129 /modules/nostotagging/libs/nosto/php-sdk/src/classes/helper/NostoHelper.php 130 /modules/nostotagging/libs/nosto/php-sdk/src/classes/helper/NostoHelperDate.php 131 /modules/nostotagging/libs/nosto/php-sdk/src/classes/helper/NostoHelperIframe.php 132 /modules/nostotagging/libs/nosto/php-sdk/src/classes/helper/NostoHelperPrice.php 133 /modules/nostotagging/libs/nosto/php-sdk/src/classes/http/NostoHttpRequestAdapter.php 134 /modules/nostotagging/libs/nosto/php-sdk/src/classes/http/NostoHttpRequestAdapterCurl.php 135 /modules/nostotagging/libs/nosto/php-sdk/src/classes/http/NostoHttpRequestAdapterSocket.php 136 /modules/nostotagging/libs/nosto/php-sdk/src/classes/http/NostoHttpResponse.php 137 /modules/nostotagging/libs/nosto/php-sdk/src/classes/oauth/NostoOAuthClient.php 138 /modules/nostotagging/libs/nosto/php-sdk/src/classes/oauth/NostoOAuthToken.php 139 /modules/nostotagging/libs/nosto/php-sdk/src/classes/operation/NostoOperationProduct.php 140 /modules/nostotagging/libs/nosto/php-sdk/src/classes/Nosto.php 141 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoAccount.php 142 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoCipher.php 143 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoDotEnv.php 144 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoMessage.php 145 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoOrderConfirmation.php 146 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoProductReCrawl.php 147 /modules/nostotagging/libs/nosto/php-sdk/src/classes/NostoValidator.php 148 /modules/nostotagging/libs/nosto/php-sdk/src/libs/phpseclib/crypt/NostoCryptBase.php 149 /modules/nostotagging/libs/nosto/php-sdk/src/libs/phpseclib/crypt/NostoCryptRijndael.php 150 /modules/nostotagging/libs/nosto/php-sdk/src/libs/phpseclib/crypt/NostoCryptAES.php 151 /modules/nostotagging/libs/nosto/php-sdk/src/libs/phpseclib/crypt/NostoCryptRandom.php 152 /modules/nostotagging/classes/helpers/account.php 153 /modules/nostotagging/classes/helpers/admin-tab.php 154 /modules/nostotagging/classes/helpers/config.php 155 /modules/nostotagging/classes/helpers/customer.php 156 /modules/nostotagging/classes/helpers/flash-message.php 157 /modules/nostotagging/classes/helpers/logger.php 158 /modules/nostotagging/classes/helpers/product-operation.php 159 /modules/nostotagging/classes/helpers/updater.php 160 /modules/nostotagging/classes/helpers/url.php 161 /modules/nostotagging/classes/meta/account.php 162 /modules/nostotagging/classes/meta/account-billing.php 163 /modules/nostotagging/classes/meta/account-iframe.php 164 /modules/nostotagging/classes/meta/account-owner.php 165 /modules/nostotagging/classes/meta/oauth.php 166 /modules/nostotagging/classes/models/base.php 167 /modules/nostotagging/classes/models/cart.php 168 /modules/nostotagging/classes/models/category.php 169 /modules/nostotagging/classes/models/customer.php 170 /modules/nostotagging/classes/models/order.php 171 /modules/nostotagging/classes/models/order-buyer.php 172 /modules/nostotagging/classes/models/order-purchased-item.php 173 /modules/nostotagging/classes/models/order-status.php 174 /modules/nostotagging/classes/models/product.php 175 /modules/nostotagging/classes/models/brand.php 176 /modules/nostotagging/classes/models/search.php 177 /modules/nostotagging/fr.php 178 /modules/fianetsceau/fianetsceau.php 179 /modules/fianetsceau/lib/includes/includes.inc.php 180 /modules/fianetsceau/lib/includes/functions.inc.php 181 /modules/fianetsceau/lib/kernel/includes.inc.php 182 /modules/fianetsceau/lib/kernel/SceauMother.class.php 183 /modules/fianetsceau/lib/kernel/SceauLogger.class.php 184 /modules/fianetsceau/lib/kernel/SceauDOMDocument.class.php 185 /modules/fianetsceau/lib/kernel/SceauXMLElement.class.php 186 /modules/fianetsceau/lib/kernel/SceauSocket.class.php 187 /modules/fianetsceau/lib/kernel/SceauService.class.php 188 /modules/fianetsceau/lib/common/includes.inc.php 189 /modules/fianetsceau/lib/common/SceauControl.class.php 190 /modules/fianetsceau/lib/common/SceauCustomer.class.php 191 /modules/fianetsceau/lib/common/SceauAddress.class.php 192 /modules/fianetsceau/lib/common/SceauOrderDetails.class.php 193 /modules/fianetsceau/lib/common/SceauProduct.class.php 194 /modules/fianetsceau/lib/common/SceauOrderProducts.class.php 195 /modules/fianetsceau/lib/sceau/includes.inc.php 196 /modules/fianetsceau/lib/sceau/lib/Sceau.class.php 197 /modules/fianetsceau/lib/sceau/lib/SceauSendratingResponse.class.php 198 /modules/fianetsceau/lib/sceau/lib/SceauSendratingCommentsResponse.class.php 199 /modules/fianetsceau/lib/sceau/lib/SceauSendratingCommentsResponseResult.class.php 200 /modules/fianetsceau/lib/includes/fianetcategories.inc.php 201 /modules/fianetsceau/fr.php 202 /cache/smarty/compile/8b/6c/82/8b6c82dea82c9aa65b539a39e8ec7aaea510877f.file.login_addons.tpl.php 203 /modules/dashactivity/dashactivity.php 204 /modules/dashactivity/translations/fr.php 205 /modules/dashtrends/dashtrends.php 206 /modules/dashtrends/translations/fr.php 207 /modules/dashgoals/dashgoals.php 208 /modules/dashgoals/translations/fr.php 209 /translations/fr/errors.php 210 /cache/smarty/compile/18/4c/52/184c521726fbe86efb944d9c656b739e1220e0a6.file.modal.tpl.php

Edited January 19, 2016 by JOE DP PNEUS (see edit history)