[thelist] CF: Query runs slower in ColdFusion than in Oracle

rudy rudy937 at rogers.com
Mon Oct 6 18:17:31 CDT 2003


> I have a fairly complex query 

that is the understatement of the month, if not the year


if it's exactly the same query in toad as in cf, then it's gotta be 
something in the way they handle the communication

do you see execution timings both ways?

how many records are being returned?  does toad show them all,
or does it perhaps come back real fast with the first twenty, 
whereas cf is not coming back until it has them all?


rudy






More information about the thelist mailing list