wp_options table questions

This topic contains 3 replies, has 3 voices, and was last updated by  lisec73 4 years, 11 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • June 9, 2019 at 11:33 pm #491843

    lisec73
    Full Member
    Post count: 180

    I use GDV2, which I updated from V1.

    My wp_options table is extremely large(30+MB). The majority of tables are from GeoDirectory and I am trying to determine whether I can delete anything.

    There must be hundreds of rows of

    Tax_meta_gd_place ### (and the same for all the other listing types)

    Geodir_revision### (from single digits and well into 8000+)

    I use the plugin WP DB Cleaner to view the tables easily. The options mentioned are not marked as “orphan”. It says they belong to “backup” – whatever that is.

    I read the following post but I’m not sure if that means I can safely delete the geodir_revision options?
    https://wpgeodirectory.com/support/topic/geodir_revision/

    Any advise on geodirectory options would be appreciated.

    Thanks
    Lise

    June 10, 2019 at 7:00 am #491909

    Kor
    Moderator
    Post count: 16516

    Hi Lise,

    Thanks for your post. Will forward this to a developer for further assistance.

    June 10, 2019 at 11:17 am #492004

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Lise,

    Those are both from v1 (and old ver) and can be removed.

    Thanks,

    Stiofan

    June 16, 2019 at 12:57 am #493169

    lisec73
    Full Member
    Post count: 180

    Thanks,
    I have cleared those rows and it removed 30MB from my options table. Everything seems to still work ok and Query Monitor has stopped complaining about slow query from WP_Core.
    Cheers
    Lise

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket