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.
