Just a point of clarification, in case anyone missed it:
Steve indicated that the problems he's seen are generally due to the
swsoc.exe process. That's the ColdFusion MX ODBC Server service,
which is there to process requests for ODBC datasources (which he said he
was using for his Informix DBs). If you don't use them, M@, then you might not
experience whatever he's hitting. Just sharing that it may be more than just
coding practices, but you make a good point.
That said, he had also indicated that he knew he should
investigate changing to the native Informix driver. While often such a change
should be simple, sometimes it's not (different drivers respond to given SQL
differently, in terms of what they permit or what they return). But, yes, the
days of restating a CF server each night really should be a thing of the past.
:-)
Again,
you may want to grab even a trial of Fusion Reactor (or SeeFusion) to see if
they show something getting hung up. They can show what's going on within the
process of CF, and identify long-running requests that no longer are connected
to a browser. I just spotted a couple today on my dev laptop. I never would have
noticed them otherwise.
/charlie
http://www.carehart.org/blog/
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of M@ Bourke
Sent: Friday, August 18, 2006 4:44 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: CF Administrator - Whitespace Management
it is in a cluster of 3 though, 2 cf servers and 1 db server.
be sure to scope all ya vars within cfc's
M@
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---