News for hackers. Stuff that matters.

A comment on Database expert on why NoSQL mattered – and SQL still matters. Parent comment

Re:Database expert on why NoSQL mattered – and SQL still mat... by amelius on Wednesday July 29, 2015 @09:20AM (#9968390)
> I want my queries to always behave the same and fail without an index.

So I take it you are not using any kind of cache in your memory hierarchy?

[ Parent | on HN ]
Re:Database expert on why NoSQL mattered – and SQL still mat... by silon7 on Friday July 31, 2015 @04:07AM (#9980539)
This exactly where I observe MSSQL dropping to table scans too soon. If indexes are cached (or when using a ssd), they will be much faster for many many records than a table scan (which will always require disk access in a realistic scenario).

I agree that table scan will be faster if I need a large percentage of the table (more than can be cached).

[ Parent | on HN ]