Hi,

On Mon, Jul 10, 2017 at 12:13:58PM -0400, Przemek Klosowski wrote:

> Could you possibly summarize what you remember about those tests? What 
> 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 <j...@xos.nl>
--    X/OS Experts in Open Systems BV   |   Office: +31 20 6938364
--    Amsterdam, The Netherlands        |   Mobile: +31 6 26216181
_______________________________________________
devel mailing list -- devel@lists.fedoraproject.org
To unsubscribe send an email to devel-le...@lists.fedoraproject.org

Reply via email to