We also removed a large delay by making sure the local tnsnames.ora file has
all the information needed to reach the database. Our DBAs originally set
up the tnsnames.ora to point at the "source" on another server. With a
little pushing and shoving we were able to get them to publish the "source"
tnsnames.ora out to the web servers. For some reason this was about a four
second lag problem the first hit to the database on each page, even with
maintain connections set, but now it is gone!
Dan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 12, 2000 5:57 AM
To: [EMAIL PROTECTED]
Subject: RE: Queries to Oracle Slow from CFAS (tds)
have you set the datasource to maintain connections? oracle is slow at
starting up a new connection, and you will see that overhead with every
query if you don't use "maintain connections".
-----Original Message-----
From: Troy Simpson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 6:39 PM
To: cf-talk
Subject: Queries to Oracle Slow from CFAS (tds)
When I run a query from an SQLPLUS Session, the query runs lighting
fast.
But, when I run the query via a CF Template and display the results to a
browser it is very slow for only 100 records.
I'm use CF 4.5.1 with Windows 2000 and the CF Native Drivers.
I've stripped out everything from the CF Template except just the
necessary stuff like <cfquery> and <cfoutput>
I have debugging turned on and time specified in the "Queries Section"
is like 134233 milliseconds (134.233 Secons).
Every once in a while I get a response time like 5432 milliseconds (5.4
Seconds)
Has anyone experienced this as well.
--
Troy Simpson | North Carolina State University
NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina
ph.919.515.3855 | fax.919.513.3330
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
