On Monday 02 Apr 2007, Mike Kear wrote:
So that's the issue - if you're going to do database accesses in
CFSCRIPT, then:
[A] think again and do them in tags like everyone else, there's
nothing wrong with that, and
[B] if you really insist on doing them in CFSCRIPT, then make sure
you
Last week, I posted a question here looking for ways to figure out
what was causing my client's server to make a huge number (as in
8500+) concurrent connections to the database. I received a number of
very helpful responses, thanks everyone, and I thought I'd post the
outcome so you all knew
Time to force the developer to read the CFWACK...
On 4/2/07, Mike Kear [EMAIL PROTECTED] wrote:
My client has a staff programmer whose background is .asp rather than
coldfusion and he's picked up coldfusion along the way piece by piece.
--
mxAjax / CFAjax docs and other useful articles:
I need some advice as to likely causes of strange behaviour on my
client's site .
About 6 weeks ago it started making an ever-growing number of
connections to the database, until finally something broke and one of
his two clustered servers would need to be rebooted and all that
server's
How can i isolate what's causing thie behaviour?
Make sure each app uses it's own login, and then use your DB admin tool of
choice to dump the list of current connections.
--
Tom Chiverton
Helping to conveniently synergize virtual features
on: http://thefalken.livejournal.com
In addition to Toms suggestion, a quick way would be to use netstat on the
sql server to see where the connections are coming from!
Paul
~|
Macromedia ColdFusion MX7
Upgrade to MX7 experience time-saving features, more
Mike
Check in the ASP code (cant remember the right syntax of the top of
my head) that they are closing their connections something like
% conn.close %
After they are done with it
MD
On 28 Mar 2007, at 11:29, Mike Kear wrote:
I need some advice as to likely causes of strange behaviour on
7 matches
Mail list logo