search

valendesigns / option-tree

Theme Options UI Builder for WordPress. A simple way to create & save Theme Options and Meta Boxes for free or premium themes.
GNU General Public License v2.0
598 stars 180 forks source link

OT_Cleanup->maybe_cleanup() slow on large multisite networks #625

Open earnjam opened 8 years ago

earnjam commented 8 years ago

I have a big multisite network (over 12,000 sites), so there are a lot of tables in the database.

SHOW TABLES LIKE queries are pretty slow since they hit the information_schema. We use OptionTree in one of our themes, and any admin request on that theme makes a SHOW TABLES LIKE call because the maybe_cleanup() function is hooked to admin_menu.

Is there any way we can limit the number of times this is called? Perhaps just run the cleanup once at theme or plugin activation?

valendesigns commented 5 years ago

Not a bad idea. I'll look into it.