On Mon, Jul 10, 2017 at 01:51:57PM +0200, Jos Vos wrote:
On Mon, Jul 10, 2017 at 02:44:31PM +0300, Alek Paunov wrote:
> If you say:
> create table col1(key blob primary key, value blob) without rowid;/
>
> you physically get no more/no less simple key/value store (given 30 more
> lines of trivial code for implementing your favorite key/value lib
> operations).
>
> But you are right - sqlite is different piece of cake: sqlite has
> powerful query language. Sqlite based backend gives the future advantage
> that big chunk of the rpm code could be elegantly and declarative
> offloaded to the query engine (with efficiency benefits as bonus).
I did performance tests to compare SQLite with LMDB for my own case here
(using key/value-like things) and the performance difference is *huge*.
How which side?
Did you blog about your test and findings?
Pierre