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
On Mon, 21 Nov 2005, Shane Baker wrote:
I'm sure I must be doing something wrong. This is my first attempt at
working with SQLite.
We'll see...
I have a simple table, with 7 columns. There are 6 integers and a BLOB,
with the primary key being on an integer. When I try to run inserts (one
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
Thank you very much for the feedback. I understand your point, hardware
takes a deterministic amount of time.
I have been basing my assumptions on these sources:
http://www.sqlite.org/cvstrac/wiki?p=PerformanceConsiderations (See
Transactions and performance)
Hi,
On Mon, 21 Nov 2005 10:56:41 -0500 (EST)
Shane Baker [EMAIL PROTECTED] wrote:
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.
Are you using sqlite on windows or MacOS X?
As I tested, sqlite performs
Thank you very much. I am happy to hear that the performance I am seeing
is in line with what others have observed. I am running this on Windows
XP.
On Tue, 22 Nov 2005, Akira Higuchi wrote:
Hi,
On Mon, 21 Nov 2005 10:56:41 -0500 (EST)
Shane Baker [EMAIL PROTECTED] wrote:
I just need to