Auto-loading options create significant database bloat

Hello guys, you really need to solve this. There was a related topic recently that you marked as “resolved” while it’s not, so I open a new one.

There are hundreds of _boxnow_parcel_order_id_* options inside the wp_options table, and the worst part is that they are autoloading. This means that in every page load we load these useless options, hurting the db performance.

First of all, if you need to create such kind of options with the parcel id (a dynamic part), you should not place them in the wp_options table. This is not the right place, use your own table, or the order meta table.

Also, even if you use the wp_options, please dont make these options to autoload, but set them autoload=>false so that they load only when needed by your plugin. You should read the update_option() documentation https://developer.wordpress.org/reference/functions/update_option/ for better understanding. Changing the autoload mode is a quick and easy fix, and I think you should consider it asap, because you are increasing the db load on all eshops.

Thank you