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

Plunkett, Matt MPlunkett at MSA.com
Tue Oct 7 09:23:22 CDT 2003

-----Original Message-----
From: Scott Brady [mailto:evolt at scottbrady.net]
Sent: Monday, October 06, 2003 6:36 PM
To: thelist at lists.evolt.org
Subject: [thelist] CF: Query runs slower in ColdFusion than in Oracle

> I have a fairly complex query that runs drastically slower in CF than it
> within Oracle (well, Toad), and I can't figure out why.  (I'll include the

> query at the end of this e-mail).  It seems to me that if a query takes 2
> seconds for Oracle to process, it shouldn't take much longer (if any
> when cfquery is run.  It certainly shouldn't take 30 seconds to run.

One thing you need to look at is your optimizer goal.  CF by default uses
"choose" I think, while SQL Navigator uses "rule".  I've had similar
problems between Navigator and ColdFusion although I use stored procs
instead of cfquery.  Get your DBA to analyze your query from ColdFusion to
see what optimizer goal it uses.

More information about the thelist mailing list