3 ms·
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
by bluestreak 7y ago
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 7y agoSo how would this compare to the naïve approach of using a cursor in another fast, memory-mapped database, like LMDB?