News for hackers. Stuff that matters.

A comment on SQL: One of the most valuable skills. Parent comment

Re:SQL: One of the most valuable skills by tremon on Wednesday February 13, 2019 @06:35AM (#19152281)
Depends a lot on the actual access patterns of your data.

Yup. Thing is: with RDBMSs you are in control of both the storage patterns and the access patterns of your data. That's where a large part of the performance benefit comes from.

> 50% of features could get by with read-only datasets that supported only key/value lookup

Did you implement a storage pattern that was ordered by key (or hash(key) if you used hashing)?

[ Parent | on HN ]
Re:SQL: One of the most valuable skills by nostrademons on Thursday February 14, 2019 @07:42PM (#19167554)
"Did you implement a storage pattern that was ordered by key (or hash(key) if you used hashing)?"

Well, I didn't implement it, Jeff Dean did, but yes, that's what we used for a lot of features.

https://www.quora.com/What-is-an-SSTable-in-Googles-internal...

https://www.igvita.com/2012/02/06/sstable-and-log-structured...

[ Parent | on HN ]