send the query it may help to see what the issue is.
-----Original Message-----
From: Troy Simpson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 3: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.
