Re:MongoDB Is Abusing JSON
by cheald on Thursday January 17, 2013 @08:55PM
(#5076601)
Are subselects still ridiculously inefficient in MySQL? It's been a long while since I've used them. I do like how those queries read, though.
[ Parent
| on HN ]
Sorry I only use proper DB's like PostgreSQL and MSSQL who optimizer's have no problems with this ;).
Also what I like about the count approach is you can do "show me all the posts with at least 2 out of the 3 tags matching" fuzzier search if you desire.