RSQLite slowness

Dear Ivan,

Thanks for that explaination!  I think 
it explains the slowness clearly.

It is possible to use carray is in Rust 
[1] so it might be available in R in the 
future(?)  I'll look into rusqlite some 
time at least.

sqlite is supposed to be one of the 
fastest sql implementations.  Realm [2] 
might be faster, but I don't know how to 
use it in R so ...  

I thought someone might suggest Redis, 
but I think it is way slower.  

sqlite with indexes and the traditional 
way of doing that by writing in a 
temporary table might just be it ... 

Best,
Rasmus

[1] https://docs.rs/rusqlite/0.24.2/rusqlite/vtab/array/index.html
[2] https://en.wikipedia.org/wiki/Realm_(database)
[3] https://en.wikipedia.org/wiki/Redis

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20211007/481d4bf3/attachment.sig>