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