News for hackers. Stuff that matters.

A comment on Select * from cloud. Parent comment

Re:Select * from cloud by tlarkworthy on Friday September 30, 2022 @02:25PM (#33038659)
NoSQL is like simple assignment to storage and one layer of obvious indexing. Its lower level, and therefore much faster and predictable because there is no query planner guessing how to assemble things.

Tuning SQL on the other hand is a guessing game with the query planner. You can express a lot more but 1% of those expressions could down your DB.

I like both, but if you want performance NoSQL is the winner.

[ Parent | on HN ]
Re:Select * from cloud by the_af on Friday September 30, 2022 @03:54PM (#33039932)
> if you want performance NoSQL is the winner.

Performance for which use cases?

It matters to clarify this because if you get rid of every use case SQL+RDBMS optimize for, NoSQL is obviously going to be the winner. A car with no safety measures and without most consumer-oriented features is probably going to be "faster" than one that has them.

[ Parent | on HN ]