I am not sure what kind of environment you have..
Can you use ODBC instead of native drivers, perhaps native drivers are
better but try ODBC..
I guess you running Oracle on a separate box.
1.Are both of your boxes on the same domain? CF server and oracle...
2. Do you have a good fast network?
other than the above , i really cant think of anything else..
I have brought down more than 50,000 record in less then 5 seconds.. soo..
Good guess should be the network or ODBC/OLEDB driver
hope this helps
Joe
----- Original Message -----
From: "Troy Simpson" <[EMAIL PROTECTED]>
To: "cf-talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 11, 2000 6:39 PM
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.
