2
Answers
Vote up!
0
Vote down!

Is there a better way to improve Drupal Commerce performance?

We're using Drupal 7 with commerce kickstart 2.10 - we're using dedicated server for our hosting, but the site's very slow compare to the hosting package - https://mukano.com
It'll be good if we can achieve the speed demonstrated here: http://demo.commerceguys.com/ck

I've optimized PHP & MySql but no significant changes, my.cnf file has the following config:
[mysqld]
max_connections = 300
key_buffer = 256M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 296
interactive_timeout = 25
wait_timeout = 7000
connect_timeout = 10
max_allowed_packet = 100M
max_connect_errors = 10
query_cache_limit = 32M
query_cache_size = 64M
query_cache_type = 1
tmp_table_size = 32M
[mysqld_safe]
open_files_limit = 65535
[mysqldump]
max_allowed_packet = 32M
[myisamchk]
key_buffer = 32M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
log-slow-queries=/var/lib/mysql/slow.log

I'm I missing something? Any suggestions 'll be appreciated, thanks.

Asked by: Philben
on December 9, 2013

Comments

Find out what's slow. Profile from all sides. Is it the server? The database? Rendering taking too long? Ask the questions.

- Bojan Zivanovic on December 10, 2013

It's rendering that's taking too long, any suggestions?

- Philben on December 10, 2013

2 Answers

Vote up!
1
Vote down!

There's nothing exceptional about Commerce stores that makes it much different from standard Drupal sites. There can be a performance hurdle depending on how you implement the cart block and deal with anonymous users.

In general (tm), you can use the same best practices of any Drupal site:

http://drupalwatchdog.com/2/1/drupal-performance-best-practices
https://drupal.org/best-practices
http://drupal.stackexchange.com/questions/tagged/performance

Also, I recommend you do some searching and reading through the vast amounts of discussion that exists on drupalcommerce.org:

http://www.drupalcommerce.org/search/site/performance
http://www.drupalcommerce.org/questions/tagged/performance

Also, I've heard there has been some success with caching blocks and ajax loading in those that aren't cacheable (carts) using the Authcache set of modules.

https://drupal.org/project/commerce_authcache

Josh Miller
Answer by: Josh Miller
Posted: Dec 16, 2013