Support Forum Support Forum GDPR Cookie Compliance wp_options table shows 1000s of rows for GDPR plugin

Topic Resolution: Resolved
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • Premium
    AvatarChris Knox
    January 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 AgencyMoove Agency
    January 31, 2020 @ 11:28 am

    Hi Chris,

    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.
    Thanks

    Moove AgencyMoove Agency
    February 06, 2020 @ 8:36 am

    Hi Chris,

    Just to let you know, this feature is now available in the latest version of the premium plugin.

    Hope this helps.

    Thanks

Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic.