"Roger Gullhaug" <[EMAIL PROTECTED]> wrote: > 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.
It is better to leave it open. Just be sure to call sqlite3_reset() or sqlite3_finalize() on each statement after it runs. -- D. Richard Hipp <[EMAIL PROTECTED]>
