"P Kishor" <[EMAIL PROTECTED]> wrote: > I get 1000+ inserts a second for a random 100 byte string > insert (
I get 50000+ inserts/sec on my Linux box. Insert speed is not the issue. It is COMMIT speed. At each commit, SQLite waits until all data is on oxide before continuing. That will typically take at least two rotations of the disk platter, or about 17 millisecond, depending on your disk drive. Waiting for data to get to oxide is part of being ACID. You can set: PRAGMA synchronous=OFF; and your COMMITs will go *much* faster because it will no longer wait on the disk drive. But if you lose power in the middle of a commit, you might corrupt your database file. Note that there is an implied BEGIN...COMMIT around every INSERT statement if you do not explicitly start a transaction using your own BEGIN. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
