On 31 Dec 2012, at 4:03am, Cory Isaacson <cory.isaac...@compuflex.com> wrote:

> We are doing some basic tests of SQLite4, and the performance seems slow. We
> also tested LSM directly and got about the same results. The test is using
> an INSERT of two integers, or 2 strings in LSM. It starts at around 9000
> INSERTs/second, then degrades to around 5000 INSERTS/second.
> 
> Both tests were also tested with bigger transaction windows (100, 1000 rows
> per transaction), with the same performance.

Can you try the same code on the same platform with SQLite3 and let us compare 
the timings between the two engines ?

By the way, I don't know how you downloaded SQLite4 but in case it didn't make 
it clear, SQLite4 is still under development and not yet considered a finished 
product.

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

Reply via email to