Re: [sqlite] SQLite4 UPDATE performance

Richard, I commented out SQLITE4_DEBUG and SQLITE4_MEMDEBUG and added -DNDEBUG=1. That did the trick! More like 224,000 updates per second. Thanks for your help Rob On Wed, Feb 27, 2013 at 5:47 AM, Richard Hipp wrote: > On Wed, Feb 27, 2013 at 3:24 AM, Rob Turpin

Re: [sqlite] SQLite4 UPDATE performance

On Wed, Feb 27, 2013 at 3:24 AM, Rob Turpin wrote: > I wrote up a test case to do some performance tests for the update > statement, and I'd thought I'd ask before probing around the code first. > > For SQLite3: 280,000 updates per second > For SQLite4: 290 updates per second

[sqlite] SQLite4 UPDATE performance

I wrote up a test case to do some performance tests for the update statement, and I'd thought I'd ask before probing around the code first. I did some comparisons with SQLite3. The update statement is like this: update pk_sk set sk=? where pk=? pk being the primary key. Using the command line