4 ms·
I tried this method for my app. But it turned out that I needed a lot of fields to be in their own columns since i would have to use them with queries in the WH
by SingAlong 17y ago
I tried this method for my app. But it turned out that I needed a lot of fields to be in their own columns since i would have to use them with queries in the WHERE clause or ORDER clause.
So be careful while choosing the columns you would like to serialize or json-ify and dump.
Just my 2c.
- technoweenie 17y agoPart of this article talks about the index tables they use. The rationale for having separate index tables is they can create or drop them without locking tables or anything like that. It takes a little more manual work to keep things updated though. I too use a hybrid approach on my site. Only columns that aren't specifically referenced in indexes aren't kept in the serialized attribute hash.