"Anthireddy, Srinivasreddy IN BLR SISL" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> This is Srinivas Reddy A, working for SIEMENS INDIA.
>
> I'm wrote one application to take the performance measurements in c++ =
> using sqlite_open(), sqlite_exec(), sqlite_close() API's how you people =
> given one sample application in the website.
>
> It's taking the for Insert 1000 records is 1min : 59sec : 889millisec =
> for table structure is 4 INTEGER's, 1 VARCHAR(100). But what you have =
> taken the test environment and given the details in website =
> (http://www.sqlite.org/speed.html) SQLite 2.7.6: 13sec.061millisec and =
> SQLite 2.7.6 (nosync): 0min.223millisec only.
>
> Can you help me out how to use the SQLite to get the good performance.
>
> Aviating for your replay.
>
> Thanks & Regards,
> Srinivas Reddy A.
Please consider using SQLite version 3 instead of SQLite version 2.
Version 3 is newer and is actively developed. SQLite 2 is in
maintenance only.
To make your INSERTs go faster, put them inside a transaction:
BEGIN;
INSERT ...;
.... -- repeat 1000 times
COMMIT;
--
D. Richard Hipp <[EMAIL PROTECTED]>
