Bill Erickson

Code Snippets / sql

Find Largest Autoloaded Options

Written by Bill EricksonUpdated on December 5, 2018

SELECT option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 10;
view raw test.sql hosted with ❤ by GitHub

Bill Erickson

Bill Erickson is a freelance WordPress developer and a contributing developer to the Genesis framework. For the past 14 years he has worked with attorneys, publishers, corporations, and non-profits, building custom websites tailored to their needs and goals.

Ready to upgrade your website?

I build custom WordPress websites that look great and are easy to manage.

Let's Talk

Other articles in this series

Building a Gutenberg website

February 18, 2019

Gutenberg is the new block-based content editor in WordPress. I’ll show you how to develop a Gutenberg-optimized WordPress theme and provide examples of client sites using Gutenberg.

Block Styles in Gutenberg

February 18, 2019

Every block type in the WordPress editor can have multiple style options. I’ll show you how to add and remove style options from blocks.

Adding Gutenberg support to WordPress theme

February 6, 2019

If you’re building custom themes for clients, you should be adding Gutenberg support right now! Make sure your client’s transition to the new editor is as seamless as possible.