[sqlite] Database Open takes most of the time??

[biju]

Hi, 
  I want to replace file based storage system with SQLite. Flat file storage is 
much faster (20-100 milli seconds) if the storage data is less. As the data 
increases the transaction(create/update/delete) time increases and reaches to 1.
1 seconds. Any Transaction(create/update/delete) in sqlite takes place in 3 
steps, open , exec and close. Time taken for any transaction (590ms) out of 
which Database open takes 520 ms, exec takes 30ms and close takes 40 ms. 
 The time consumtion for open is too large. Is there any way to optimize it. Can 
i avoid each time open and close of the database(Eny cache settings)??

regards
+biju

-
This mail sent through Tejasnetworks Webclient


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

RE: [sqlite] CppSQLite

[Rob Groves]

>>There is no copyright statement or license stated in the article
>>or in the download.
>>So it isn't clear what the legal status is of CppSQLite?

There is a copyright notice at the end of every CodeProject article.

However, I now intend to add a BSD style licence to all the source
code files.

Thanks,

Rob.


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