Support

Search results for ""

Sorry, no results found. Perhaps you would like to search the documentation?
All Topics
Moises

Data overload in wp_options by AdminColumns with ac_cache_data_

hello, my site is old and i have a very big wp_options table. I’m doing a careful cleaning of data left behind by hundreds of plugins I’ve used, but I can’t find which plugin created the “ac_cache_data_” option. From the initials of the option name, I assume it is from the Admin Columns, correct? If yes, can I safely wipe this data? how do I prevent this plugin from overloading my wp_options table like this?

query: https://i.imgur.com/C0BDE0m.jpeg

4 weeks, 1 day ago
Stefan
Developer

First of all, yes, this is an option created by our plugin. The option contains the cached options for the drop-downs on top of the table overviews used by our filtering feature. Since retrieving the values for the filters can be heavy on performance, we cache it so that it does not have to be retrieved for every page request.

1) You can clean all options with that prefix, but they will be re-created if you have filtering enabled for your columns
2) We’re working on a way to clear all cache-related options from our settings menu
3) I believe that we can improve the filtering feature, but only load the options in the drop-down once the drop-down is opened. That way we don’t need to cache the result and thus we don’t need to cache it in the database. I’ve added this to our backlog.
4) You can use our Smart Filtering feature instead of the Filtering feature to completely prevent the creation of the cached options.

4 weeks, 1 day ago
Moises

hello Stefan. Thanks for the answer. Please also added to the backlog create a statement to remove these ac_cache records when uninstalling the plugin. I tested it here on staging site and saw that the plugin does not clean the wp_options table, neither uninstalling nor clicking on “restore default settings”

4 weeks, 1 day ago

You must be logged in to reply to this topic.