On Feb 25, 2007, at 10:03 AM, Alex Cheng wrote:
I want to know how many time is spent when create a sqlite
connection. Is it
effeciency? My application creates a connection and close it when
access DB
everytime, is it OK?
Hello Alex,
every time you open an sqlite database file, the sqlite library has
to parse all table structures. It is much better to keep your
connection/handle open for longer periods of time.
Cheers, Peter.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------