RE: OLE DB and Maintain Connections

2003-01-16 Thread Bryan Love
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?

Re: OLE DB and Maintain Connections

2003-01-15 Thread Paris Lundis
Sounds like shared hosting... or do you have you own dedicated box? Disabling the database connections as steady state can be good in some circumstances... I have some things I run this way and others that I try always to maintain... The OLE isn't the first choice... wondering why they

Re: OLE DB and Maintain Connections

2003-01-15 Thread Ian Lurie
Yah, we have a dedicated box. We've spent two weeks checking the cf logs, etc. and can't find a thing. The hosting co. keeps e-mailing us and copying our client saying it has to be our code. Sigh. I don't even care if it IS our code at this point - I just want to fix the @)#$(*! thing.

Re: OLE DB and Maintain Connections

2003-01-15 Thread Paris Lundis
in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Ian Lurie [EMAIL PROTECTED] Date: Wed, 15 Jan 2003 13:44:09 -0800 Subject: Re: OLE DB and Maintain Connections Yah, we have a dedicated box. We've spent two weeks checking

Re: OLE DB and Maintain Connections

2003-01-15 Thread jon hall
Wednesday, January 15, 2003, 4:26:21 PM, you wrote: IL Hi all, IL We've got a server that's suddenly become very cranky - running slowly, IL hanging, etc. 3-4 times per day. When you say hanging, do you mean the CF process, or the entire machine? If the entire machine is locking, then it's