Tom J Nowell talks about abusing post meta in a recent blog post. Querying by meta data is pretty much always a bad idea, and Tom explains why you should look at using taxonomies instead.
Joe and I talked about indexing meta (you can hack meta keys sometimes to work more efficiently), as well as using taxonomies and custom tables instead, amongst many other ways to scale WordPress, on the podcast not too long ago.
