Thank you for pointing out the omitJournal argument to sqlite3BtreeFactory!
That's just what I was looking for.
By forcing omitJournal to 1 in all cases (thereby always turning off
journaling), I was able to increase the total speed of my application by a
factor of 2.5 over the speed I got by just
Holding commits with a timeout is a feasible solution. However, in my
application it is somewhat complex to implement. Multiple threads are
accessing the database, and read requests usually run in a different thread
than writes. I don't want reads to be blocked while a commit timeout waits,
so a
> Do you know that the performance without doing anything special is
unacceptable?
If I do insertions of a test set of 2000 records using a BEGIN
TRANSACTION/COMMIT around each one, the speed is 20 times slower than doing
additions in a single transaction. I hacked the winSync routine and remove
I have an application that requires creating a database with about 50
million records. Is there any way to turn off journaling and rollback
during the creation? I am willing to sacrifice reliability for speed in this
situation.
___
sqlite-users mailing
atus = sqlite3BtreeData(BtCursor,0,DataSize,buf);
ASSERT(strcmp(buf,Data2) == 0);
/* Close the cursor */
status = sqlite3BtreeCloseCursor(BtCursor);
/*
* Close the database.
*/
status = sqlite3_close(db);
/*
* Finished
*/
return;
}
I would like to see the Btree routines
5 matches
Mail list logo