That sum() SQL is all you do as a user. There is no additional magic there. The ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		bluestreak on April 7, 2020 \| parent \| context \| favorite \| on: Using SIMD to aggregate billions of values per sec... That sum() SQL is all you do as a user. There is no additional magic there. The performance numbers are indeed best when data is in memory. However in reality sum() goes over memory mapped file, lazy loading data as required.

heartbeats on April 8, 2020 [–]

So how would this compare to the naïve approach of using a cursor in another fast, memory-mapped database, like LMDB?

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact