Cold Fusion opens a certain amount of connections and keeps them open for
re-use. This connection pooling allows CF to reuse connections rather than
incur the overhead of creating/deleting the connection for every page
processed. This is by design, and is considered a good thing.
There are settings in the CF Administrator to turn this feature off, or
limit the number of open connections.
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
-----Original Message-----
From: Brian W. Zaleski, DC, MS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 27, 2000 12:18 PM
To: [EMAIL PROTECTED]
Subject: RE: CF-Talk V1 #104
Chris,
I dunno about that. We had someone come out from Allaire a few months ago
and analyze one of the sites that I work on. They have some metrics that
they use as far as how the code is written, and apparently we did quite
well.
We are running CF 4.51 with J-Run on a couple of Sun boxes with SQL Server
7.0 (obviously on another box....LOL). We are using Java servlets to process
some WDDX and do some other neat stuff.
I was talking to our Director of IT last night (a guy with 8-10 years of
Unix experience) and basically his take on it was that he couldn't wait to
get rid of the ColdFusion. He said that one of the biggest problems was that
the CF Server would report that there were open connections even when there
weren't. The Sun boxes would be humming along at 10%, no hits to disk, the
DB server is also at 10%, but no one could get in because the CF server
wouldn't release the connections.
Too bad you don't have the OPTION to do something like:
myQuery.Close
Set myQuery.ActiveConnection = Nothing
Set myQuery = Nothing
Sure it's more code, but it would easily solve the problem.
Brian Zaleski
[EMAIL PROTECTED]
> From: "Chris Evans" <[EMAIL PROTECTED]>
>
> If I want to run a serious high-power site, I would go to
> Solaris, or maybe
> now Linux on Intel to get the most bag for the buck. Did I see
> someone who
> said 40 servers? I don't know about Linux with CF, but I know
> for a fact I
> can run a major e-commerce site on 4 Sun boxes with an external DB server.
> I don't know the price points where massive redundancy on the NT
> side takes
> over for the reliability of Solaris, but I think any argument on highly
> scalable sites needs to look at Unix, if not as its sole focus,.
>
> Chris Evans
> [EMAIL PROTECTED]
> http://www.fuseware.com
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
