Hey,
I put e-commerce on Drupal 7 Commerce using Kickstarter.
URL: http://wydawnictwo-oaza.pl/
Page initially worked well, but now the page loading speed is terrible. There are even 10s.
Aggregation files js / css is selected, the compression too.
Performance modules:
Commerce EntityCache
Entity cache
DB Maintenance
Boost
Boost Crawler
The server provides a tool for the verification scripts, recent results are as follows:
CPU Utilization (%) 47
The use of ram (kb) 232368
Number of files read 469
Number of stored files 0
Execution time of 0:02.50
By size (kb) 3148
Number of external links html 29
Number of queries external script 1
Number of queries sql select 209
Number of queries sql update 2
SQL execution time (in seconds) 0126
Longest execution time sql query (in seconds) 0009
The longest sql query
SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN ('system_list')
CPU utilization (%) 40
The use of ram (kb) 225856
Number of files read 469
Number of stored files 0
Execution time of 0:02.85
By size (kb) 2944
Number of external links html 29
Number of queries external script 1
Number of queries sql select 209
Number of queries sql update 2
SQL execution time (in seconds) 0137
Longest execution time sql query (in seconds) 0019
The longest sql query
SELECT cid, data, created, expire, serialized FROM cache_views WHERE cid IN ('ctools_export:views_view:commerce_addressbook', 'ctools_export:views_view:commerce_addressbook_defaults', 'ctools_export:views_view:commerce_backoffice_orders', 'ctools_export:views_view:commerce_backoffice_order_messages', 'ctools_export:views_view:commerce_backoffice_user_orders', 'ctools_export:views_view:commerce_cart_form', 'ctools_export:views_view:commerce_cart_block', 'ctools_export:views_view:commerce_cart_sum...
Unfortunately the server does not allow the use of memcached.
I also tried to use the patch of http://groups.drupal.org/node/274838 but there was no difference.
List all enabled modules:
Name Version
Automatic Nodetitles 7.x-1.0
Backup and Migrate 7.x-2.4
Boost 7.x-1.0-beta2
Boost Crawler 7.x-1.0-beta2
CCK Blocks 7.x-1.1
Chosen 7.x-1.0+17-dev
CKEditor Link 7.x-2.2
Colorbox 7.x-1.4
Commerce AutoSKU 7.x-1.1+1-dev
Commerce Backoffice Order 7.x-2.0-rc2
Commerce Backoffice Product 7.x-2.0-rc2
Commerce Cash on Delivery 7.x-1.0-alpha1
Commerce Checkout Progress 7.x-1.2
Commerce Custom Order Status 7.x-1.0
Commerce EntityCache 7.x-1.0-alpha1
Commerce Extra Rules Conditions 7.x-1.x-dev
Commerce Kickstart Block 7.x-2.0-rc2
Commerce Kickstart Checkout Redirect 7.x-2.0-rc2
Commerce Kickstart Content UI 7.x-2.0-rc2
Commerce Kickstart Lite Product UI 7.x-2.0-rc2
Commerce Kickstart Menus 7.x-2.0-rc2
Commerce Kickstart Merchandising 7.x-2.0-rc2
Commerce Kickstart Order 7.x-2.0-rc2
Commerce Kickstart Search 7.x-2.0-rc2
Commerce Kickstart User 7.x-2.0-rc2
Commerce Price Savings Formatter 7.x-1.3
Commerce Stock 7.x-1.1
Commrce Print label
Crumbs 7.x-1.5
Customer UI 7.x-1.4
Delta Blocks 7.x-3.0-beta11
Delta UI 7.x-3.0-beta11
Dostawa
Entity cache 7.x-1.1
Fences 7.x-1.0
Field Multiple Limit 7.x-1.0-alpha3
Image resize filter 7.x-1.13
IMCE Wysiwyg API bridge 7.x-1.0
jQuery Update 7.x-2.2
Line Item UI 7.x-1.4
Locale 1.07.2016
Menu attributes 7.x-1.0-rc2
Mime Mail CSS Compressor 7.x-1.0-alpha2
Module filter 7.x-1.7
Node view permissions 7.x-1.0
Options element 7.x-1.8
Pathauto 7.x-1.2
Payment UI 7.x-1.4
PHP filter 1.07.2016
Product Pricing UI 7.x-1.4
RDF 1.07.2016
Scheduler 7.x-1.0
Simple Field Formatter 7.x-1.0
Simplenews 7.x-1.0
Smart Trim 7.x-1.3
Tax UI 7.x-1.4
Taxonomy menu 7.x-1.4
Title 7.x-1.0-alpha4+4-dev
Transliteration 7.x-3.1
User registration password 7.x-1.3
Variable 7.x-2.1+7-dev
Views PHP 7.x-1.x-dev
Views UI 7.x-3.5
Webform 7.x-3.18
Thanks in advance for any help
Regards,
Chris