- PremiumChris KnoxJanuary 31, 2020 @ 8:47 am
We have noticed that the website is running quite slowly, and after some investigation we have identified a problem with the wp_options table – specifically the autoload field where the value is set to ‘yes’.
There are at least 1600 rows inside wp_options with entries for gdpr_addon_geo_full.
I have run a few tests using MySQL Workbench where I delete the rows and then apply the changes. As soon as I do that the entries reappear again.
Do you have any idea why this is happening?
Were are using the standard GDPR plugin and one paid extra which enables us to not hide the cookie banner for none EU users,
Kind regards and looking forward to your reply,Moove AgencyJanuary 31, 2020 @ 11:28 am
Thanks for reporting this.
When you activate the GEO location feature, we ask external 3rd party system which country is the IP address from that just accessed your site. We need to do this to determine whether to show the user the Cookie Banner or not.
We don’t want to be sending too many requests to the 3rd party service, so the solution was to store the IP address with the value in the wp_options table and avoid asking 3rd party service for the same IP address repeatedly.
It seems your site must be very popular and has lot of hits, which is why the wp_options get quickly populated.
So you are right, it would be better to move this functionality into a separate table and not use wp_options at all.
We’re currently working on the update and it should be released by the end of next week.
In the meantime, if it’s possible for you, you can switch the geo feature on your site temporarily until this update is available.
Hope this helps.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.