[ad_1]
[ad_2]
Hi everyone,
I’m looking for advice on optimizing my WordPress database for better performance. I’m using WooCommerce, and I’m curious if indexing is beneficial for my setup. If so, could someone guide me on how to implement indexing effectively?
I’m open to any general tips or best practices for database optimization as well. Thanks in advance!
[removed]
It’s not nearly big enough to experience a noticeable speed difference. If you’re experiencing issues with speed it’s likely the amount of RAM you have allocated to your server, which is a hosting problem, not a DB problem. RAM is by far the biggest bottle neck when it comes to speed.
Try to use as few plugins as possible, use a good caching Plugin, use a CDN, optimize Images, css, js… There’s a lot you can optimize!
WP-CLI has the command “wp db optimize” for this. Back up your db first before attempting anything.
Quite a bit. Check both the MySQL and Database optimization sections:
https://docs.google.com/document/d/1ncQcxnD-CxDk4h01QYyrlOh1lEYDS-DV/
Can you share the URL of your website?
For 10 products only it is unlikely that DB optimization could have a noticeable impact.
Do you have access to phpmyadmin?
Persistent object caching. Redis is great if you have it, otherwise sqlite is a good alternative.
Adding indexes to commonly used tables is another option. See this plugin: [https://wordpress.org/plugins/index-wp-mysql-for-speed/](https://wordpress.org/plugins/index-wp-mysql-for-speed/) and this: [https://www.plumislandmedia.net/wordpress/performance/woocommerce-key-improvement/](https://www.plumislandmedia.net/wordpress/performance/woocommerce-key-improvement/)