Ka Yue
Forum Replies Created
-
Same issue here! huge performance issue for us as we edit post often.
We did not pick WooCommerce for performance. We pick WooCommerce because it is easy to modify and fit our team’s background (WordPress developer). We tried to use Magento before but it was too difficult for us to modify.
I don’t know how many traffic do you have and I couldn’t even imagine how can you manage 500k products and inventory…
Redis and ElasticSearch is just something bonus. We have 2 in house programmers working full time on the site thus we are able to use these “advance” technology. (Well, in fact they are industry standard in the IT world).
Technical details:
WooCommerce store customer’s cart information in WordPress’s option table (MySQL), and it is a lot of read and sometime write to database. So we use Redis to store these information because Redis can handle them a lot faster. Redis’s performance is as fast as Memcache. (The end result is it didn’t improve that much). Beside this everything else is still in MySQL.
We also use ElasticSearch for a faster, better search. WooCommerce’s search is just an exact match on product title. And the product filter in the sidebar is really a performance killer in our site, ElasticSearch helped us quite a lot in our case.
And I am a fan of Bootstrap, our store is using Bootstrap as the CSS framework too. Go take a look at getbootstrap.com.
@varktech.com
In multisite mode, WordPress create a set of new tables for each blog. It will be more difficult to handle one large blog. You will need to do a lot of optimization in your theme to keep your site fast.
Also keep in mind that store is a lot more dynamic then a static blog, makes thing hard to cache. WordPress is flexible but at the end it isn’t designed for ecommerce use case, you cannot even run a sales report in WooCommerce if you have a large store.
We have 1 web server (c1.xlarge) and 1 database (m1.xlarge). We made a lot of optimization in our theme, but didn’t hardcode any thing in WooCommerce, so yes, if you have the skill and time, WooCommerce can handle quite a lot of traffic.
Optimization including use ElasticSearch for search page and product filter, Redis for WooCommerce session storage etc.
Also I would suggest you upgrade to the latest WooCommerce version, there are lots of things need to be fix under the hood so you better keep it up to date.
Even WordPress can hardly handle 500k entries. WooCommerce will be even worst.
Imagine all your orders, products, and blog post will be sharing the same table, your post table will grow fast.
If the post table doesn’t break your server, the categories and post meta table will.
PS: I manage store.hypebeast.com
Forum: Plugins
In reply to: [W3 Total Cache] W3TC is clearing object cache every minutesI have the following plugins installed:
Installed Plugins: All in One SEO Pack by Michael Torbert version 1.6.15.3,
Capability Manager by Jordi Canals version 1.3.2,
Category SEO Meta Tags (modified to work with our store brand pages – Warren) by Bala Krishna, Sergey Yakovlev version 2.3,
Crony Cronjob Manager by Scott Kingsley Clark version 0.4.1,
WooCommerce CSV Export by Ilari Mäkelä version 1.6.4,
WooCommerce Google Product Feed by Lee Willis version 1.5.5,
WooCommerce Product CSV Import Suite by Mike Jolley version 1.2.2,
WooCommerce Sequential Order Numbers by Justin Stern version 1.2.4,
WooCommerce Smart Coupons by Store Apps version 1.2.8.2,
WooCommerce Table Rate Shipping by Mike Jolley version 2.6.2,
WooCommerce by WooThemes version 2.0.5Forum: Plugins
In reply to: [W3 Total Cache] W3TC Memcached & Nginxkey and group should be constant
The final key would look like something like this:
w3tc_key_domain.com_2_object_fe2395a32fa21f59d9c1cc21442438ea_2Format:
w3tc_key_<host>_<blog id>_<module>_<compiled key + group>_<blog id>I suggest you use APC first and then use apc.php to view all the keys used by w3tc.
Forum: Plugins
In reply to: [W3 Total Cache] W3TC Memcached & NginxSorry it should be:
if(class_exists('W3_ObjectCache')) { $w3_key = W3_ObjectCache::instance()->_get_cache_key($key, $group); }You need to know the $key and $group first, can be found in debug mode.
Forum: Plugins
In reply to: [W3 Total Cache] W3TC Memcached & Nginx$key = ‘your cache key’;
if(function_exists(‘w3_instance’)) {
$w3_key = w3_instance(‘W3_ObjectCache’)->_get_cache()->get_item_key($key);
}