On Mon, Jul 10, 2017 at 12:13:58PM -0400, Przemek Klosowski wrote:
Could you possibly summarize what you remember about those tests?
scenario did you look at? Was the difference more like seconds vs hours,
or microseconds vs milliseconds?
I found some of my old mail back. In my tests a full processing cycle
for reading and processing (JSON deserializing in my case) data,
measured on a large amount of operations, was 4 times faster in LMDB
than in SQLite.
Note that this includes application processing (at this moment
I can't recall what that test did, it was 1,5 year ago...), so the
pure difference in DB processing time might even be much larger.
In general, I agree that SQLite is a fast DB when comparing, for
example, with ProgreSQL. I did tests for that too in the past and
the difference is huge (and the feature set difference is huge too ;-)).
BTW, I'm pretty sure Howard Chu, the author of LMDB, would be happy to
discuss things with the Fedora/RPM community, if someone is interested.
-- Jos Vos <jos(a)xos.nl>
-- X/OS Experts in Open Systems BV | Office: +31 20 6938364
-- Amsterdam, The Netherlands | Mobile: +31 6 26216181