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
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!



Klaus Major
klaus at major-k.de

More information about the use-livecode mailing list