B2BKing adds hundreds of option to the wp_options table, and they are all set to autoload. This puts enormous stress on the server. Can I change them to autoload=no?
While indeed the plugin adds hundreds of options, we haven't usually seen these to take up a large size or impact performance. I am wondering why you say these put a large stress on the server.
Are there specific options of B2BKing that you are seeing take up a large size? Do you have any other information?
If you can run this SQL query, it would help us know what the total size of B2BKing autoloaded options in your database is:
SELECT SUM(LENGTH(option_value)) as autoload_size FROM wp_options WHERE autoload='yes' AND option_name LIKE '%b2bking%';
I think it won't be a problem to change them all to autoload = no, but I don't know if the total performance impact from that will be positive or negative.
The total size is 7315. That seems like a lot to load in every time whether they are required or not. I'm often told to reduce the number of autoloads, and that plugins that autoload excessive data are not well coded...
That size is in bytes, so it would mean the size in MB is 0.007 MB, which is a very small size. In that case I don't think it can have any effect at all on performance.
For example https://kinsta.com/knowledgebase/wp-options-autoloaded-data/ here it references that "So in our case, 249,025 bytes equals 0.25 MB. So for this site, this is a good size! If you return anything below 1 MB you shouldn’t be worried."
B2BKing adds hundreds of option to the wp_options table, and they are all set to autoload. This puts enormous stress on the server. Can I change them to autoload=no?
Hi there,
While indeed the plugin adds hundreds of options, we haven't usually seen these to take up a large size or impact performance. I am wondering why you say these put a large stress on the server.
Are there specific options of B2BKing that you are seeing take up a large size? Do you have any other information?
If you can run this SQL query, it would help us know what the total size of B2BKing autoloaded options in your database is:
I think it won't be a problem to change them all to autoload = no, but I don't know if the total performance impact from that will be positive or negative.
Kind regards,
Stefan
The total size is 7315. That seems like a lot to load in every time whether they are required or not. I'm often told to reduce the number of autoloads, and that plugins that autoload excessive data are not well coded...
Hi again,
That size is in bytes, so it would mean the size in MB is 0.007 MB, which is a very small size. In that case I don't think it can have any effect at all on performance.
For example https://kinsta.com/knowledgebase/wp-options-autoloaded-data/ here it references that "So in our case, 249,025 bytes equals 0.25 MB. So for this site, this is a good size! If you return anything below 1 MB you shouldn’t be worried."
Ok, fair enough. Thanks.