No, as I mentioned in my original message, I am not wrapping them. I don't want to test an unrealistic scenario for my application. In my application, there are multiple sources that will be inserting into the database and pooling the information for a bulk insert won't work.
I understand that I will get better performance by inserting all of my rows inside a transaction. What I don't understand is why, when NOT using a transaction, I get about 7 inserts per second compared to others who are reporting between 200 and 300. I am working with reasonable hardware. I just need to figure out why my performance is about 30x slower than what others are reporting when using the library in similar ways. On Mon, 21 Nov 2005, Chris Schirlinger wrote: > Are you wrapping the transactions in between Begin/End Transactions? > > BEGIN TRANSACTION; > INSERT INTO table (foo) VALUES (bar); > INSERT INTO table (foo) VALUES (par); > INSERT INTO table (foo) VALUES (tar); > INSERT INTO table (foo) VALUES (far); > .. > INSERT INTO table (foo) VALUES (car); > INSERT INTO table (foo) VALUES (jar); > INSERT INTO table (foo) VALUES (mar); > COMMIT TRANSACTION; > > Check out this document for more info > http://www.sqlite.org/lang_transaction.html > > > I'm sure I must be doing something wrong. This is my first attempt at > > working with SQLite. >
