Tips and tricks to keep Woocommerce running smoothly after a few years

I’d like to find out if those of you that have Woocommerce shops with large amounts of plugins/functionalities (eg 40+ plugins – feeds, automated mails, etc) have any particular optimization solutions besides the regular ones.

After being away from WordPress development for 3 years, I was faced with a situation in which database queries were really slow (postmeta table around 5million rows) and the solution was to add SQL indexes on all the columns in that postmeta table (not my solution, hosting provider did that).

I was wondering if this is something people often look into with regards to optimizing/speeding up their WordPress instances.

I was thinking that the WordPress installer which is setting up the database would set the columns indexes as efficient as possible.

Could it be that this is already not scaling up anymore?

Is this a common issue for medium-large setups?

Let me hear your thoughts, thanks!

  1. Good question. I am where you were 3 years ago. Anybody got recommendations how to keep this ship sailing smoothly?


This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer