postmeta size

  • Resolved kris110846

    (@kris110846)


    6 years, 8 months ago

    Quite often when i go into products it times out with a 504 error. We have been told by our hosting admin that we are over using resources by running queries like
    SELECT rb_posts.ID FROM rb_posts LEFT JOIN rb_postmeta ON ( rb_posts.ID = rb_postmeta.post_id ) | 0 | 31 |
    SELECT SQL_CALC_FOUND_ROWS rb_posts.ID FROM rb_posts LEFT JOIN rb_postmeta ON ( rb_posts.ID = rb_p | 0 | 31 |
    is this related to – https://github.com/woocommerce/woocommerce/issues/11913 – this issue, as at the moment we have 1.6m rows in our post meta table and our hosting company has just taken our site offline for over user of resources.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

  • Hi @kris110846,

    It sounds like you might be running a store with many products, is that right? How many products do you have?

    WooCommerce and WordPress do need more resources to run queries that have to loop through hundreds or thousands of products to do so.

    My suggestion:
    * Try updating WooCommerce to the latest version (3.3.3)
    * Disable all other plugins and switch to a default theme, see if you are still getting a 504 error then
    * Consider moving to a host that can support the kind of resources you need to run your store.

    Thread Starter kris110846

    (@kris110846)

    At the moment we have between 9 & 10,000 products, is there an upper limit which is suggested for the number of products on a shop.

    We are on WC 3.3.3 at the moment.

    Hi @kris110846,

    Did you try disabling all other plugins except WooCommerce to see if that made things better? If it’s still not the speed you would like when trying that, I would suggest looking into a different hosting option to help you with this problem.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘postmeta size’ is closed to new replies.