A simple test on my dev site gave:
When autoload is off, wppa requires 488 queries, in the normal situation only 28 to load the frontpage.
So, do you really want that???
Aoart from a few user dependant options, only settings that are not set to the default have an option item in the options table.
Where is the warning coming from??
Thread Starter
pfm
(@pfm)
Dear Jacob,
thank you for your insights. The Warning comes from WordPress “Site Health”. I found several recommendations to keep the wp_options table clean (some plugins leave garbagge in when deinstalled and some leave temporary stuff in). The recommendation is to have not too much autoload to “on” as far as I understood.
As I’m a user for approx. 10 years for your great plugin, there might be stuff in that I never used but did “play around” with the settings (so they are no longer default). If I understand you correct, going back to default would delete the unused entries? 365 sounds for a lot of “not default” entries. Is this a common amount of special options?
I’m not 100% sure, but I think site health gives the warning at approx. 1200+ entries. I reduced my entries by deleting some “temporary” and some misused entries (some plugins write whole paragraphs as values). So I’m beneath the warning but if it makes sense (performance wise) I would “clean up” inside my WPPA settings as well.
Thank you!
Yes, if you revert to default setting, it deletes the option entry.
Nevertheless, you turned on my thinking mechanism that leads me to the following plan for a future version (maybe not next week):
That i will save the array of non-default wppa options as one entry (array will be serialized automatically); makes it faster but theoretically prone for overflow when large entries are entered for e.g. default photo description or custom php procs. Maybe only the yes/no switches possibly all (should not be too big) or non-default only.
Takes som more thinking and coding, especially conversion to this approach. Keeps me from the street, as we say in Holland…
