Re: [sqlite] SQLite4 Performance

Thanks...progress...now we get a SIGBUS later on... Program received signal SIGBUS, Bus error. 0x0046ce4c in treeShmalloc (pDb=0x6c9728, bAlign=0, nByte=25, pRc=0x7fffd784) at src/lsm_tree.c:668 668 pNext->iNext = 0; pRc looks suspiciously like it's ready to overflow

Re: [sqlite] SQLite4 Performance

On 01/31/2013 11:13 PM, Michael Black wrote: Do we still get to report bugs? I checked out the fossil repository fossil clone http://www.sqlite.org/src4 sqlite4.fossil I tried my insert test and ran into a problem. I'm running Redhat 5.7 gcc 4.4.4 This program dies (showing inserts/sec)

Re: [sqlite] SQLite4 Performance

On 12/31/2012 11:03 AM, Cory Isaacson 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

Re: [sqlite] SQLite4 Performance

g); } #endif memcpy(key,,8); memcpy([8],,8); memcpy(value,,8); rc=sqlite3_bind_blob(stmt2,1,key,16,SQLITE_STATIC); checkrc(db,SQLITE_OK,rc,1,"Error bind1 statement '%s': ",sql); rc=sqlite3_bind_blob(stmt2,2,value,16,SQLITE_STATIC); checkrc(db,SQLITE_OK,rc,1,"E

Re: [sqlite] SQLite4 Performance

On 31 Dec 2012, at 4:03am, Cory Isaacson 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

[sqlite] SQLite4 Performance

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