On Tue, Nov 5, 2019 at 10:01 AM Wout Mertens <wout.mert...@gmail.com> wrote:
> On Mon, Nov 4, 2019 at 10:26 PM Jens Alfke <j...@mooseyard.com> wrote: > > > I don't have a practical use for the branching features, though they're > cool, but I'm salivating at the thought of a 2x speedup. > > With all the work that's put into eking out small performance increases > in SQLite, I'd imagine the devs would be interested in > > something that made that big of a difference... > > What I would like to know is how such a performance increase is > achieved, and why regular SQLite can't do the same? > AFAIK, that was one of the goals of SQLite4 [1], to change the backend to LSM. We know now SQLite4 is basically abandoned, but LSM was refactored as an SQLite3 extension [2]. Here's an article that goes into more depth on the subject [3]. Hope this helps. --DD [1] https://sqlite.org/src4/doc/trunk/www/index.wiki [2] https://www.sqlite.org/src/dir?ci=5710845b6314f924&name=ext/lsm1 [3] https://charlesleifer.com/blog/lsm-key-value-storage-in-sqlite3/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
