Duplicate db queries (migration) ?

  • Resolved pulpita

    (@pulpita)


    9 months ago

    On Query Monitor, Independent Analytics generates duplicate database queries (7+ identical calls to iawp_db_version and iawp_is_migrating per page load). ‘Claude’ tells me it might be related to migration hooks running continuously instead of completing. Is this normal ? I’m afraid it may be the cause of admin slowdowns. 

    SELECT option_value
    FROM options
    WHERE option_name = 'iawp_db_version'
    LIMIT 1    70,0072
    7 appels
    Extension : independent-analytics
    7 appels
    IAWP\Migrations\Migrations::is_migrating()
    1 appel
    IAWP\Migrations\Migrations::handle_migration_18_error()
    1 appel
    IAWP\Migrations\Migrations::handle_migration_22_error()
    1 appel
    IAWP\Migrations\Migrations::handle_migration_29_error()
    1 appel
    IAWP\Patch::patch_2_8_7_potential_duplicates()
    1 appel
    IAWPSCOPED\{closure}()
    1 appel
    IAWP\Migrations\Migrations::should_migrate()
    1 appel
    SELECT option_value
    FROM options
    WHERE option_name = 'iawp_is_migrating'
    LIMIT 1    60,0056
    6 appels
    Extension : independent-analytics
    6 appels
    IAWP\Migrations\Migrations::is_migrating()
    1 appel
    IAWP\Migrations\Migrations::handle_migration_18_error()
    1 appel
    IAWP\Migrations\Migrations::handle_migration_22_error()
    1 appel
    IAWP\Migrations\Migrations::handle_migration_29_error()
    1 appel
    IAWP\Patch::patch_2_8_7_potential_duplicates()
    1 appel
    IAWP\Migrations\Migrations::should_migrate()
    1 appel


Viewing 1 replies (of 1 total)
  • Plugin Author Ben Sibley

    (@bensibley)

    9 months ago

    Thanks for getting in touch about this.

    In some of our updates, we need to change the database structure and it’s important to run these changes immediately. Unfortunately, WordPress does not have a way for plugins to run code immediately after updates, so we have to check at the beginning of each page load to make sure that the plugin hasn’t just updated. We don’t have any other options until WP adds a way for us to run these functions after an update.

    With that said, Query Monitor also shows that the combined impact of these queries is only 0.0021 seconds, so the impact is negligible and will not cause a perceivable change in performance.

Viewing 1 replies (of 1 total)

The topic ‘Duplicate db queries (migration) ?’ is closed to new replies.