Running Long Sync Query on Every Page Load

  • Resolved Brad Slusher

    (@bslush)


    2 years, 9 months ago

    We are only using the plugin to have Square do the payment processing, but this REALLY LONG (6.15 second) SQL query is running with every page load:

    SELECT option_value
    FROM wp_options
    WHERE option_name LIKE ‘wc_square_background_sync_job_%’
    AND ( option_value LIKE ‘%\”status\”:\”queued\”%’
    OR option_value LIKE ‘%\”status\”:\”processing\”%’ )
    ORDER BY option_id ASC
    LIMIT 1

    The query is being called by: WooCommerce\S\F\U\Background_Job_Handler->get_job()

    We have product sync disabled of course.

    No background sync job should be called at any point, and only the payment code called during checkout.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Igor H

    (@ihereira)

    2 years, 9 months ago

    Hello,

    I understand there is a long SQL query is running with every page load, despite the fact that you are only using the Square plugin for payment processing and have product sync disabled. I understand the concern about the query’s impact on the website’s performance or loading speed.

    Can you provide us a screenshot of the issue on your end?

    If you keep only WooCommerce and Square for WooCommerce as the only active plugins, and set up a default theme like Storefront, does the issue persist? If not, you will want to run a conflict test to help you find the cause of the issue.

    Let us know what you find.

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    2 years, 9 months ago

    Since we haven’t heard from you for a while, I’m marking this as resolved. We’re always here to help.

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

The topic ‘Running Long Sync Query on Every Page Load’ is closed to new replies.