Re:Lessons from My Mistakes: Start with MySQL
by al2o3cr on Monday August 14, 2017 @03:07PM
(#15011633)
+1 to premise of the title, but these specific reasons don't hold much water.
* "no tooling": searching Google for "mongodb ui" turns up - even before the organic results - three PAID results for different tools. I'd suspect you'd see similar results for most any reasonably popular NoSQL option.
* table scans: table scans can be expensive in both approaches. You'll get exactly the same performance problems doing the queries described against a SQL database; the number of records required to be considered "a lot" may be different. The fix is similar in both: indexing.
* "no tooling": searching Google for "mongodb ui" turns up - even before the organic results - three PAID results for different tools. I'd suspect you'd see similar results for most any reasonably popular NoSQL option.
* table scans: table scans can be expensive in both approaches. You'll get exactly the same performance problems doing the queries described against a SQL database; the number of records required to be considered "a lot" may be different. The fix is similar in both: indexing.