But I am really like in my testing result.
I did 15 M insert in maybe 10 transaction and I am really happy with the
performance.
I did not use any long filed as index.
-----Original Message-----
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 3:13 PM
Cc: [EMAIL 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 set (25,000+ records) in one transaction.
I
> found that I was able to improve performance slightly by committing after
> every 10,000 records. Either way, the performance is still too poor.
>
> 2) I am going directly to the dll (not using ODBC).
>
> 3) I am already using PRAGMA default_synchronous=OFF
>
* Are you writing to a local disk or to a network filesystem?
* Please show use your schema and an example INSERT, complete
with data.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
