Re: [sqlite] Performance Issue with SQLite Inserts

[John LeSueur]

Wempa, Kristofer (Kris), ALABS wrote:
-----Original Message-----
From: Soham Mehta [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 3:22 PM
To: [EMAIL PROTECTED]
Subject: [sqlite] Performance Issue with SQLite Inserts
Hello,

Obviously, this does not match up with the performance tests that appear
on
the website.  Is there something that we are doing wrong?  Any help or
guidance that you can provide would be greatly appreciated.

Regards,
Soham

How are you loading all of this data into the sqlite database.  I notice
that bulk loading from a file using "COPY" works pretty good.  A bunch
of single inserts performs poorly.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 

Also, have you tried putting all of the inserts/copy commands inside of 
a single transaction?  Sqlite likes transactions,
and does much better with large sets of inserts inside transactions.

John LeSueur
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]