> Over the weekend I was speaking to a friend of mine also an
> Oracle Guru and
> he asked me a basic question on Using CFQUERY. His question was
> that while
> making a connection to a database how does it (CFQUERY) handle
> opening and
> closing a connection to a database (you know like opening and closing a
> socket connection )? Does anyone know how this is done in CF?
You can configure the number concurrent DB connections per datasource (not
per CFQUERY) seperately in the CFAdmin. You can specify that CF keeps those
DB connections open and re-uses them, or you can make CF drop and recreate
the DB connection with each new DB request. You can also specify how many
concurrent threads CF has running at any given time.
> Another question would be how does one log number of concurrent users
> connected to the DB or as a matter of fact to CF server (if someone wants
> to restrict number of users at a time)? I am using MS SQL 7.0 server, IIS
> 4.0.
On WinNT, these stats can be determined with the new CF 4.5 function
"GetMetricData()". The full list of things which this function can return
are:
InstanceName
PageHits
ReqQueued
DBHits
ReqRunning
ReqTimedOut
BytesIn
BytesOut
AvgQueueTime
AvgReqTime
AvgDBTime
CachePops
-Cameron
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
