It's not a comprehensive test, but I thought readers here may be interested
to see the results of some testing I've just completed comparing the
Berkeley DB SQL API through Oracle's .NET wrapper (System.Data.SQLite) vs.
the SQLite 3 engine and the sqlite.org edition of System.Data.SQLite.

You can find the blog post, results and code here:
http://www.tsjensen.com/blog/2011/09/10/SystemDataSQLite+Write+Comparison+Of+SQLite+3+Vs+Berkeley+DB+Engines.aspx

I ran into a bug with the Berkeley implementation on reads, so for that
reason alone, I'd stick with SQLite, but I also did not find any significant
advantage for inserts from multiple threads (running on a 6 core machine).

If anyone else has experimented with this and achieved different results,
I'd love to hear about it.

-Tyler
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to