Re: [sqlite] Performance Issue with SQLite Inserts

[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.
 
<SNIP>
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,
First a few questions...  Are you running the entire import in one 
transaction?

Are you using ODBC or right to the DLL?
Have you tried using PRAGMA synchronous = OFF?
see:
http://sqlite.org/lang.html#pragma_default_synchronous
(* where it says its 50% faster this way, and warns about corrupting the 
db *)

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