Options tables disappearing? Why our platform doesn’t allow large options tables.
At WP Engine we strive to promote best practices to make your site run efficiently. When using a theme or plugin it is important to store data in a way that is quick for WordPress to retrieve it. It is also important to do this in a way that does not interfere with other core functions of WordPress. That is why our platform does not allow you to store large amounts of information in the wp_options table of your site’s database.
How the wp_options table works:
Every call of get_option() in your site requires a database read to all rows in the table. Storing large amounts of data in the options table could be a bottleneck in your site’s speed. This is because every call of this common core function requires your site has to crawl through the many rows stored to find what it’s looking for. When there are many rows, rows with lots of content, or both it is taxing on the server to resolve your site. To prevent this from being an issue, our infrastructure regularly cleans up large options by removing them.
What is a large option?
We are passionate about promoting best practices when dealing with your information and must run these scheduled tasks to keep your site running fast and to keep users engaged with your content. If you notice any issues and have any questions about how our platform handles large options tables, please consult our articles, or feel free to contact us.