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]
