Re: [sqlite] Closing database connection after each transaction?

2013-11-12 Thread Stelling Carsten
Discussion of SQLite Database Betreff: Re: [sqlite] Closing database connection after each transaction? On Tue, Nov 12, 2013 at 8:06 AM, Stelling Carsten < carsten.stell...@goerlitz.com> wrote: > Hello SQLite users, > > I was wondering, if closing the database connection after e

Re: [sqlite] Closing database connection after each transaction?

2013-11-12 Thread Richard Hipp
On Tue, Nov 12, 2013 at 8:06 AM, Stelling Carsten < carsten.stell...@goerlitz.com> wrote: > Hello SQLite users, > > I was wondering, if closing the database connection after each transaction > is a good idea. > No, it is usually a bad idea. There are non-trivial costs associated with reopening t

[sqlite] Closing database connection after each transaction?

2013-11-12 Thread Stelling Carsten
Hello SQLite users, I was wondering, if closing the database connection after each transaction is a good idea. Possibly I've missed the thread concerning this topic. If this is true, please supply me with this link. Otherwise, can anybody give a reliable advice to do it in this or that way. I