RE: [sqlite] Performance Issue with SQLite Inserts

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

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 set (25,000+ records) in one transaction. I found that I was able to improve performance sligh

RE: [sqlite] Performance Issue with SQLite Inserts

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

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

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

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 the

RE: [sqlite] Performance Issue with SQLite Inserts

-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

[sqlite] Performance Issue with SQLite Inserts

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. The data is in 6 sets of XML files (each set holds 2 day