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

[Jeff Howden]

rudy & scott,

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> > I have a fairly complex query
>
> that is the understatement of the month, if not the year
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

+1 to that.

yowch.

scott, i commend you for barely having your head around the database.

><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> 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?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><

a quick way to test this is to set maxrows on the <cfquery> to 1.

a couple more questions, is the database server and coldfusion located on
the same machine?  if not, how are they connected and are you accessing them
via toad in the same manner that cf does?

do you get any performance gains by tweaking the blockfactor setting of
<cfquery>?

which database driver are you using for coldfusion?

thanks,

.jeff

——————————————————————————————————————————————————————
Jeff Howden - Web Application Specialist
Résumé - http://jeffhowden.com/about/resume/
Code Library - http://evolt.jeffhowden.com/jeff/code/