Posts Tagged ‘ mysql performance ’

tuning mysql / mariadb database for WooCommerce and WordPress

WooCommerce can really give mysql or mariadb a pounding. On smaller hosting platforms WooCommerce will grind to a halt. If you have a VPS, here are a few things you can tune, to give you fast database performance. The faster the database goes, the faster WooCommerce goes: InnoDb cache Assuming of course that you’re […]

Optimizing WordPress and WooCommerce for thousands of products

Even though WooCommerce is immensely popular it struggles when you add thousands of products. Here is how we optimize for our customers. We recently had a customer who plonked 85,000 products into their database (thanks woo commerce import pro !). Our first observation, the pages were slow, starting at about 1.4 seconds per page. Then […]