Plugin generates excessive database queries

  • After experiencing performance problems with my site(s), I’ve tracked the problem down to this plugin. When active in a website running the Site Editor, it runs around 500 additional database queries on the search page.

    A regular call to the search page without the plugin active runs around 60-70 database queries. When the plugin is active, it varies between 550-600 queries. Using Query Monitor to analyse them, it seems that these additional queries are almost all to WP_Term_Query->get_terms(), which is called (on average) 393 times.

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Munir Kamal

    (@munirkamal)

    Thank you for reporting the issue. I will investigate the problem and get back to you with updates soon.

    Thread Starter Mark Howells-Mead

    (@markhowellsmead)

    Thank you for your swift response.

    Zofster

    (@zofster)

    +1 I have same problem.

    Any solutions?

    Best regards, Zlatan

    Zofster

    (@zofster)

    I just back to version 1.40.4 and reduced number of Queries from 664 to acceptable 196.

    Seems that Block Styles Manager is involved.

    intmanu

    (@intmanu)

    Hi,

    I too have the same problem. Is there any solution for this?

    robruifrok

    (@robruifrok)

    Same here. I get an out memory error or a timelimit error. The problem is in the Gutenberghub_Styles_Manager_Blocks class. Switching off the styles manager or commenting out the wp_insert_term function in the code solves the problem.

    Looking further I found that get_terms() with ‘fields’ set to ‘count’ gives a number of more than 250000.

    To get at least some terms returned I have to limit the number.

    Setting fields to ‘id=>name’ or ‘id=>slug’ gives odd results for name or slug.

    robruifrok

    (@robruifrok)

    Some additional info:

    In my case the problem was caused by the plugin ‘User Access Manager’ (UAM).

    In UAM->Settings->Taxonomies settings select ‘Blocks’ in the select field and make sure you set ‘Hide empty Blocks’ to ‘no’.

    If in UAM ‘Hide empty Blocks’ is set to ‘yes’ and in Editorskit ‘Styles manager’ is switched on, Editorskit multiplies the terms for the taxonomy ‘Blocks’ (name=>gsm_block) on every page load resulting in the described problems.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Plugin generates excessive database queries’ is closed to new replies.