Message-ID: <YV8D3Ibp8bDtd3iR@posteo.no>
Date: 2021-10-07T14:27:40Z
From: Rasmus Liland
Subject: RSQLite slowness
In-Reply-To: <20211007115809.2e83938e@arachnoid>
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>