Support » Plugin: Query Monitor » Query Monitor Reports Slow Query on WPMUDEV Domain Mapping Plugin

  • Resolved SooBahkDo

    (@soobahkdo)


    Hello,

    WP 4.9.8 multisite network with about 60 sites
    Using WPMUDEV Domain Mapping and WPMUDEV Multidomains

    Query Monitor reports a slow query as follows:

    SHOW TABLES

    domainmap_launch()
    wp-content/plugins/domain-mapping/domain-mapping.php:144
    Domainmap_Plugin->set_module()
    wp-content/plugins/domain-mapping/classes/Domainmap/Plugin.php:174
    Domainmap_Module_System->__construct()
    wp-content/plugins/domain-mapping/classes/Domainmap/Module/System.php:45
    Domainmap_Module_System->_upgrade()
    wp-content/plugins/domain-mapping/classes/Domainmap/Module/System.php:134
    Domainmap_Module_System->table_exists()
    wp-content/plugins/domain-mapping/classes/Domainmap/Module/System.php:206
    Plugin: domain-mapping
    Rows: 17449
    Time: 0.0634

    The qty of 17k rows in the domain mapping table seemed high and inspection of the table indicates it only has 44 rows in it.

    What would cause query monitor to miscalculate the number of rows?

    Can this be addressed?

    Thanks.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author John Blackbourn

    (@johnbillion)

    WordPress Core Developer

    The query is SHOW TABLES, which shows all tables in the database.

    How could we tell the plugin to show tables related just to the website ID? That would fix the problem, right? Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Query Monitor Reports Slow Query on WPMUDEV Domain Mapping Plugin’ is closed to new replies.