get_available_variations extremely slow

  • Hello,

    We’ve been running our site for a year now and it’s gotten progressively slower. I’ve found the problem but can’t explain why it’s happening.

    The custom SHOP page takes 12 seconds to load. Using Query monitor I got the following results:
    Page generation time: 10.3685
    8.6% of 120s limit

    Peak memory usage: 82,361 kB
    10.5% of 786,432 kB limit

    Database query time: 0.0470

    Database queries: SELECT: 280
    SHOW: 3

    Object cache: 99.9% hit rate (884,415 hits, 495 misses)
    External object cache not in use

    When I remove get_available_variations() and use a custom query the page is substantially faster. The big difference seems to be the hit rate:

    Page generation time: 1.8729
    1.6% of 120s limit

    Peak memory usage: 88,765 kB
    11.3% of 786,432 kB limit

    Database query time: 0.0600

    Database queries: SELECT: 376
    SHOW: 3

    Object cache: 99.4% hit rate (78,387 hits, 501 misses)
    External object cache not in use

    Any ideas as to why this could be happening?

    Using Woocommerce 1.6.13

    Thanks!

  • The topic ‘get_available_variations extremely slow’ is closed to new replies.