Feature request
Join 800.000 users and install The Privacy Suite for WordPress locally, automated or fully customized, and access our awesome support if you need any help!
Feature request
Missing a feature? Add a feature request and we will review your request. We might ask for more information if needed.
- 600.000+ Users
- Awesome Support
- Easy Configuration for Complex Features
- 30-Day Money Back Guarantee
5
votes
DB queries optimization
Complianz is a rather heavy plugin. On every page request our sites have more than 150 queries with “select * from wp_cmplz_cookies where ID = ‘XX'”.
A little load optimization would be great.
Top Requests
- 6.0 Get rid of jQuery - Vanilla JS 1142 Votes
- 6.0 Build cookie banners with Elementor Pop-ups 262 Votes
- 6.0 Automatically accept services for bots? 124 Votes
- 5.2 New Region: South Africa POPIA 55 Votes
- Extra US States and Update for California 45 Votes
Hi David,
Thanks for your feedback.
On the front-end, there are two ways this query may run:
– For the cookie policy. I will add the wp_cache_set and wp_cache_get functionality there, which should resolve the duplicate queries for this page. But please note that this occurs only on the cookie policy, not on other pages.
– When consent per service is enabled. When this feature runs, the cookies are requested on each pageload, but this list is stored in a transient to ensure these queries only run once. If you have these duplicate queries on each pageload, your site may be clearing transients continuously.
While the improved database queries will also help for the consent per service configuration, allowing the transients to function will help even more.
Please contact me directly at rogier(at)really-simple-plugins.com if you have any questions or remarks about the above.
Rogier