> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Yuriy Kaminskiy > Sent: Monday, April 28, 2014 8:36 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] When to open/close connections > > Simon Slavin wrote: > > On 28 Apr 2014, at 11:11pm, RSmith <rsm...@rsweb.co.za> wrote: > > > >> Second approach is better when you rarely access the database, also > it will make sure releases happen (or at least provide immediate errors > if not), but keeping a connection open is much better when hundreds of > accesses happen in terms of speed - especially loads of small queries, > large queries won't matter either way. > > > > I add two other reasons to Ryan's: if you are extremely short of > memory (for example in a tiny low-power device) or if your file system > lacks proper flushing because although flush() is documented in reality > it does nothing. > > s/flush/sync/. > However, I don't see just how closing/opening db will make it any > better. > Database/journal is written and synced at transaction end, not at > "connection" > close.
Does closing the connection force, or at least encourage, the OS to write to disk whatever it might have been caching? CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
