SQLite, keep connection open or close every time?

Klaus major-k klaus at major-k.de
Tue Nov 24 11:20:29 EST 2015


Hi Bob,

> Am 24.11.2015 um 16:48 schrieb Bob Sneidar <bobsneidar at iotecdigital.com>:
> 
> 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 <klaus at major-k.de> 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
klaus at major-k.de





More information about the use-livecode mailing list