News for hackers. Stuff that matters.
Re:The Design Of SQLite4 (work in progress) by swah on Wednesday June 27, 2012 @06:42PM (#4169560)
Yeah, also I thought that comparison was a little out of place...
Re:The Design Of SQLite4 (work in progress) by Splenivore on Wednesday June 27, 2012 @07:17PM (#4169696)
In all fairness, the LevelDB guys made the comparison first: http://leveldb.googlecode.com/svn/trunk/doc/benchmark.html

Maybe outperforming LevelDB is a design goal for SQLite 4?

Re:The Design Of SQLite4 (work in progress) by rozim on Thursday June 28, 2012 @10:13AM (#4171750)
The leveldb page shows mixed results wrt sqlite3 - I would say that it is generally faster that sqlite3 based on the results. There is no comparison to sqlite4.

Most notably in large value operations, and also slightly in random reads, sqlite3 wins. In in other benchmarks however, leveldb is faster.

The leveldb page notes that they perform poorly with large values due to the increased I/O that is done. The relatively poor random read performance isn't discussed but my guess is that it's due to having to fetch a compressed page of data that contains values for other keys, thus leveldb is doing "more work" than strictly necessary.