Serious DB bloat needs to be fixed!

I’ve been troubleshooting some slowness in WP Admin as well as the front-end on a few sites and I’ve tracked down a *huge* issue with Popup Builder. It seems when saving a post, Popup Builder triggers a few DB queries/updates that are just shocking. The first query is a select:

SELECT term_id, meta_key, meta_value
FROM wp_termmeta
WHERE term_id IN (...

and includes every term on the site which in this case is 42,788 IDs. Second, it then creates a transient called “_transient_sgpbGetPostsAllCategories” that is over 15MB! As you can imagine that slows down WP Admin quite a bit but to make matters worse, it queries that transient on every page/post on the front-end. Obviously on a busy site this generates quite a bit of DB traffic for what I would consider non-critical functionality.

This is definitely a show-stopper and must be fixed quickly! In the meantime I would not recommend using this plugin on a large, busy site.