Hi Bob, > Am 24.11.2015 um 16:48 schrieb Bob Sneidar <[email protected]>: > > IMHO always best to close after you are done. What if your computer crashes? > What if the network goes down? Closing the connection ensures everything is > tidied up.
thank you for your oponion, good points! Just made a quick test, LC 7.1.1 RC3, OS X 10.11.1, MacMini with a SSD: … repeat 100 opend_db close_db end repeat ... Took 383 millisecs, I can live with that :-) > Bob S > > >> On Nov 24, 2015, at 07:25 , Klaus major-k <[email protected]> wrote: >> >> Hi friends, >> >> see subject, any PROs or CONs to keep a db connection to a local SQLite >> database >> (deskton and mobile) open during a session or better close and reopen every >> time >> you access the db? >> >> Any opinions and hints appreciated! >> Thanks in advance! Best Klaus -- Klaus Major http://www.major-k.de [email protected] _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
