Thank you,
do you also think it will be a safe practice for the db or
keeping it open all the time could also easily damage the db?
Thks
----- Original Message -----
From: "Trey Mack" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, September 25, 2007 2:03 PM
Subject: Re: [sqlite] Openinig 1 or more connections to db
At the moment I open 1 connection to the SQL Serv.. at the moment of
login and I keep it open until the user exit the program.
Can I do the same with SQLite, or do you suggest to open and close the
connection every time I need it? Will I lose Performance?
As I understand it, that's the way to do it to maximize cache benefits.
Um.. to clarify.. keeping the connection open is the way to maximize cache
benefits. My first response was a bit ambiguous.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
