Dear Richard, Thank you for your fast response and clarification on this topic.
Regards, Carsten -----Ursprüngliche Nachricht----- Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Im Auftrag von Richard Hipp Gesendet: Dienstag, 12. November 2013 14:08 An: General 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 each transaction > is a good idea. > No, it is usually a bad idea. There are non-trivial costs associated with reopening the database connection. > 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 found some conflicting posts on other lists, and I'm unsure to > procceed. > In fact, opening and closing the DB connection for each transaction will > waste CPU ressources and time. But possibly there is a reason to do so. > Assuming that fsync() works correcly, there should be no need to close the > DB connection, if only a few processes are using a single DB. > My operating system is Linux and the SQLite 3.7.9 database files are > stored in NAND Flash. > > Regards, > > Carsten > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users