RE: [sqlite] Performance Issue with SQLite Inserts

2004-06-24 Thread Alex Wang
PROTECTED] Subject: Re: [sqlite] Performance Issue with SQLite Inserts Soham Mehta wrote: > Thanks you for all of the ideas. Here are answers to the various questions: > > 1) Currently, I am committing after every 10,000 inserts. Initially, I was > running all of the inserts of a

RE: [sqlite] Performance Issue with SQLite Inserts

2004-06-24 Thread Soham Mehta
DataLoaderTest\DataLoaderTest.sln 5) build 6) run (you can do this directly from the debugger) 7) click on "Load Data" -Original Message- From: andy [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 2:38 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Performance Issue with SQLi

Re: [sqlite] Performance Issue with SQLite Inserts

2004-06-24 Thread Michal Zaborowski
As mentioned before try with putting all your inserts into begin end block. In that way there is no way to query the file from other proces. Any way check pragma directives ie. make bigger cache size... -- Regards, MichaƂ Zaborowski (TeXXaS)

Re: [sqlite] Performance Issue with SQLite Inserts

2004-06-24 Thread 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

Re: [sqlite] Performance Issue with SQLite Inserts

2004-06-24 Thread andy
Soham Mehta wrote: Hello, We recently switched to SQLite in our application and have not been able to get the performance that partially motivated the switch. Our application downloads TV guide data from the internet and loads it into a local database. Obviously, this does not match up with

RE: [sqlite] Performance Issue with SQLite Inserts

2004-06-24 Thread Wempa, Kristofer \(Kris\), ALABS
-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, We recently switched to SQLite in our application and have not been able to get the performance