Not having to re-establish the connections repeatedly helps with
performance.
-Original Message-
From: Mike Kear [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 11:02 PM
To: CF-Talk
Subject: RE: A Tip (maybe new, maybe not)
What's the advantage of locking the server
,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Subject: Re: A Tip (maybe new, maybe not)
Go into the CF Admin and uncheck maintain database connections and your
database wont lock at all unless it's actively being
: Re: A Tip (maybe new, maybe not)
Using SQL Server maintaining the connection would be advantageous
because their wouldn't be the overhead for making a new connection,
logging in, etc. In Access I don't think it matters. It is only Access
after all. If I get concerned about performance of a site
I don't know if any of you work with Access much as a database here and there, but I
have been developing using an access database and had to upload it to our servers
after looking at the data or correcting the data as I was writing scripts ..well as
you all know it locks so you cannot FTP
Email [EMAIL PROTECTED]
Hello Stupid, and welcome to your crappy computer.
- Strong Bad, HomestarRunner.com
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 9:32 AM
To: CF-Talk
Subject: A Tip (maybe new, maybe not)
I don't
:32 AM
To: CF-Talk
Subject: A Tip (maybe new, maybe not)
I don't know if any of you work with Access much as a
database here and there, but I have been developing using an
access database and had to upload it to our servers after
looking at the data or correcting the data as I
= cfusion_dbconnections_flush()
This code flushes all connection information from the cache, but it does not
disconnect any actively running requests.
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 1:25 PM
To: CF-Talk
Subject: Re: A Tip (maybe new, maybe
: RE: A Tip (maybe new, maybe not)
Might be dangerous
Question Is there any way to disconnect from a database programmatically?
Answer This is possible, but not recommended, especially if it is a
multi-user database. To do so, however, clear the cached connection
information with the following code
What usually I do is upload the database to a new name and change the ODBC
connection to point to the new file.
-- Sam
-Original Message-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 10:25 AM
To: CF-Talk
Subject: Re: A Tip (maybe new, maybe
Or you could just run the undocumented function to release it:
CFUSION_DBCONNECTIONS_flush()
:-)
Sharon DiOrio
- Original Message -
From: Paul Giesenhagen [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 12:32 PM
Subject: A Tip (maybe new, maybe not)
I
: Thursday, May 16, 2002 12:25 PM
To: CF-Talk
Subject: Re: A Tip (maybe new, maybe not)
Even slicker thanks!
Paul Giesenhagen
QuillDesign
There is an undocumented CF Function that will do the same thing.
CFUSION_DBCONNECTIONS_FLUSH()
I used to use the bogus query to do this as well
(maybe new, maybe not)
Date: Thu, 16 May 2002 11:32:09 -0500
I don't know if any of you work with Access much as a database here and
there, but I have been developing using an access database and had to upload
it to our servers after looking at the data or correcting the data as I
was writing
This is considered bad practice, although it does work. Running an
intentionally bad query is not good practice, you never know how it will
affect your data
There is a ColdFusion function (undocumented, I believe) called
cfusion_dbconnections_flush which will perform the same function.
Are you serious?
select whatever from notable
How will that affect the data?
Paul Giesenhagen
QuillDesign
This is considered bad practice, although it does work. Running an
intentionally bad query is not good practice, you never know how it will
affect your data
There is a
*/
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, 17 May 2002 3:48 p.m.
To: CF-Talk
Subject: Re: A Tip (maybe new, maybe not)
This is considered bad practice, although it does work. Running an
intentionally bad query is not good practice, you never know
how
://www.matthewwalker.net.nz/inform2
*/
-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, 17 May 2002 3:48 p.m.
To: CF-Talk
Subject: Re: A Tip (maybe new, maybe not)
This is considered bad practice, although it does work. Running an
intentionally bad query
(maybe new, maybe not)
This is considered bad practice, although it does work. Running an
intentionally bad query is not good practice, you never know
how it will
affect your data
There is a ColdFusion function (undocumented, I believe) called
cfusion_dbconnections_flush which
Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, 17 May 2002 2:18 PM
To: CF-Talk
Subject: RE: A Tip (maybe new, maybe not)
Then use this one:
CFUSION_DISABLE_DBCONNECTIONS (DataSource, switch)
I think the switch is a Boolean value.. (?)
At 03:56 PM 5/17/2002 +1200
Go into the CF Admin and uncheck maintain database connections and your
database wont lock at all unless it's actively being accessed by CF.
jon
Paul Giesenhagen wrote:
I don't know if any of you work with Access much as a database here and there, but I
have been developing using an access
What's the advantage of locking the server on to the database at all? Is it
performance?
Cheers,
Mike Kear
Windsor, NSW, Australia
AFP WebWorks
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Subject: Re: A Tip (maybe new, maybe not)
Go into the CF Admin and uncheck
20 matches
Mail list logo