Woocommerce Database Results Slow

  • Hi All,

    I have a woocommerce site with 25k products. The search functionality takes 15 seconds to load results. When i click on a product from the product catalog, it takes 6 seconds to load the product page.

    This is really slow. Thus, i am asking if anybody knows a solution to this?

    Any guidance will be much appreciated.

    PS: My site speed is optimized with high scores on gtx metrix. I am asking to resolve database related issues.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    How are you hosting your site? You need to both tune the database server (google “Mysql tuning”) and cache the heck out of it.

    Some good info here: https://wp-rocket.me/blog/object-caching-use-wordpress/

    Thread Starter jagman123

    (@jagman123)

    I am hosting it on VPS server. I use a cdn for hosting the images. My site is relatively low traffic(at the moment) and cpu usuage isnt really that high. Still the search functionality is giving slow results (same with clicking on a product page). How would caching help? Since my cpu is not at high capacity anyway.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Caching means that you don’t have to re-do the db query. Read up on both object caching and database tuning. With 25K items, you really need to tune the server for the database.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Woocommerce Database Results Slow’ is closed to new replies.