Hi,
i disagree. As far as i understand sqlite, if you sqlite3_finalize()
your statement and close your transaction, there is no reason why the
connection can not remain open. It will not hinder any reading processes.
Martin
Chethana, Rao (IE10) schrieb:
I think its better to close, since there is another process reading from
this db.
-----Original Message-----
From: Roger Gullhaug [mailto:[EMAIL PROTECTED]
Sent: Monday, March 20, 2006 2:20 AM
To: [email protected]
Subject: [sqlite] Open->executeSql->close
Hi,
I'm writing an application that writes to SQLite at least once per
second. Is it wise to close the connection between each SQL call or is
it better to leave the connection open while the program is running?
This is a server application that will run for days and hopefully weeks
and months... There is another process which reads from this SQLite db.
