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. Are there configuration or build options that could be slowing it down? Also on OS X 10.8, for some reason the sqlite4 command line utility breaks saying that it cannot open the database. Running from C code works fine however. Thanks, Cory -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users