A marketing_opt_in column stores the current answer and nothing else, and the question that gets asked is always “when, and to what exactly did they agree”. Append-only is…
Options, tables, scheduled events, user meta and post meta all survive deactivation and deletion unless the plugin explicitly removes them, and most do not. The constant check is…
Orders live in wp_posts with their data in wp_postmeta, which means a shop with two hundred thousand orders has a postmeta table with several million rows shared with…
Dropping an index that turns out to be load-bearing means rebuilding it on a large table under pressure, so unused-looking indexes accumulate for years because nobody wants to…
All three number rows within a partition and they disagree about ties, which is invisible in test data where nothing ties and obvious in production where everything does.…
Products have always been posts, which is why a catalogue of any size ends up fighting wp_postmeta. The CRUD layer puts a data store between the object and…
3.0 moved order item data into its own tables and left the old access functions working, which means a query written against the old shape returns results and…