Many attributes, slow loading

  • Resolved herjafader

    (@herjafader)


    3 years, 8 months ago

    I have a Woocommerce site with around 2500 product attributes (and around 30 000 values).
    This is causing the product edit page to load extremely slow (around 60 sec).
    If I temporary disable attributes via function.php, the site loads in around 2-3 sec.
    It’s not variable products, but just simple products with many attributes for information.
    The edit page load slow wether or not the product has any attributes connected.

    Is there any way around this problem?

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

    (@conschneider)

    Engineer

    3 years, 8 months ago

    Hi @herjafader,

    Let’s try a MySQL index.

    * Take a full database backup.
    * Activate: https://wordpress.org/plugins/index-wp-mysql-for-speed/

    Does that change anything?

    Kind regards,

    Thread Starter herjafader

    (@herjafader)

    3 years, 8 months ago

    Hi!
    Tried now and there was just a small improvement, 55s load instead of 60s.

    Mirko P.

    (@rainfallnixfig)

    3 years, 8 months ago

    Hi there!

    What’s your server environment? Do you have enough resources to handle that number of products and attributes? It would be a good idea to get in touch with your host’s support team as they should have tools to check what is slowing down your product admin page.

    You can also go with database optimization using a plugin like WP-Optimize and run a conflict test to rule out conflicting code with WooCommerce core.

    You can find a more detailed explanation on how to do a conflict test here:

    https://docs.woocommerce.com/document/how-to-test-for-conflicts/

    After that, if you need more help, kindly share a copy of your site’s System Status. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Cheers.

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

The topic ‘Many attributes, slow loading’ is closed to new replies.