Speed up your Web App by 1000% with 1 Line of SQL
carsonified.com
carsonified.com
By the way have I ever told you guys about the time we denormalized this table... :P
Transparency is one more arrow in the quiver of the NoSQL camp. Throwing a SQL query at a black box and hoping that it figures out the most efficient way to execute that query is a scary way to access your data in a real-time application, especially when the query plan can change drastically based on what data is in the database.
I hope to never have to sleep with my hand on my phone waiting for Nagios text messages again. I'll take consistent data access performance characteristics, thank you very much.
And if the distribution of your data changes, or you move the application to a new machine? Hard-coding a particular data access strategy into your application logic is like hard-coding assumptions about the distribution of your data and the relative costs of various operations. That's not necessarily the wrong choice, but it isn't a panacea, either.
(If you're that concerned about query plan stability, many DBs give you the ability to force the optimizer to choose a particular query plan.)
Good SQL programmers know to only use it for prefix-matching, where it is very fast.
Bad ones (like the author of this post), don't know SQL, and use some query builder tool.
NEVER use an SQL query builder!
NoSQL! :)