Plugin generates excessive database queries

[github-actions[bot]]

Support

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]_

Details

• Support Author: Mark Howells-Mead
• Support Link: https://wordpress.org/support/topic/plugin-generates-excessive-database-queries/
• Latest Activity: 31 minutes ago

• Spinup Sandbox Site: https://tastewp.com/new/?pre-installed-plugin-slug=block-options

  Note: This support issue is created automatically via GitHub action.

[CiaranGruber]

Any updates on this @ZafarKamal123? I've done my own analysis to find that Editor's Kit creates by far the most database queries performing 466 queries and taking about 0.2s total. It's a useful plugin though it adds an extra 30% on total page load time which is a lot for a plugin that is often used for small changes.

It seems that the plugin already supports enabling/disabling features in the settings, why not use this to only perform queries for features that are in use? I'd imagine this could massively improve performance for those that care enough about performance to disable unused features