The most common complaint against NoSQL is that if you know how to write good SQL queries then SQL works fine. If SQL is slow you can always tune it and make it faster.
Let’s keep in mind two things:
- performance is not equivalent to scalability
- most NoSQL databases have been created to deal with scalability issues. And they offer a different, non-relational, data model.
A NoSQLite might counter that this is what key-value database is for. All that data could have been retrieved in one get, no tuning, problem solved. The counter is then you lose all the benefits of a relational database and it can be shown that the original was fast enough and could be made very fast through a simple turning process, so there is no reason to go NoSQL.
There’s the third thing too: you shouldn’t always obey the Law of the instrument. Polyglot persistence is a viable option.
Original title and link: Tunning SQL, No Need for NoSQL (NoSQL databases © myNoSQL)