The hosting company is on crack. If you have a low traffic site and a weak
server then you MIGHT be ahead to NOT maintain DB connections. This is
because holding DB connections open is expensive from a hardware resource
perspective. Using OLE for your DB connections is nuts. Why would you?
What is their reasoning behind this recommendation?
Are you storing any client vars in the registry? That can kill your
server's performance...
Also, you may want to restrict resources for SQL Server - it will chew up
ALL your resources if you let it (I've seen it happen). You'll need a DBA
to investigate just how much RAM and disk space SQL Server is allowed to
consume.
I've also seen CFX tags that caused a server to stop responding sometimes.
Are you using any of these?
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Ian Lurie [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 1:26 PM
To: CF-Talk
Subject: OLE DB and Maintain Connections
Hi all,
We've got a server that's suddenly become very cranky - running slowly,
hanging, etc. 3-4 times per day.
The hosting company told us that we should:
1. Uncheck 'maintain database connections' for all ODBC datasources.
2. Only use OLE DB for MSSQL datasources.
Both of these seem counterintuitive to me - OLE DB is buggy as all get
out, and I've always been told that 'maintain database connections' is
a performance enhancer, not a drag.
We're using CF 4.5.1 - traffic levels are about what they've always
been, and all session/app vars are appropriately locked.
Any input?
Ian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
