What is the best storage strategy for scalability?
Performance-wise I would think that a flat table is the fastest way for MySQL to access data, even if some fields in the record might be empty. It will likely take more disk space, but it should be faster to query. Is my assumption correct?
If this is true, then I should create one flat table with all my custom fields in an unserialised fashion (so that I can also quickly do searches using meta-queries), so that each post has 1 record in this custom table with all custom fields, independently of its post type.
Thoughts?
.
