Archive
schema-design
-
MySQL 5.7 JSON columns, and the regrets that followed
A support lookup read 2.4 million rows to return 41 of them, because the predicate sat inside a JSON document. The generated column fix, the two details that broke it first, and what I keep out of documents now.