Does it run slow from SQLPlus when executed from the web server itself? For perhaps a "quick" fix I'd probably try throwing it into an SP and calling that to see if the delay in executing goes away.
On 7/8/05, Ian Skinner <[EMAIL PROTECTED]> wrote: > > I'm told about 10, but those ten are summations of a lot of data from some > very large (100,000's of records) tables. > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org <http://www.BloodSource.org> > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > ....-----Original Message----- > ....From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > ....Sent: Friday, July 08, 2005 1:39 PM > ....To: CF-Talk > ....Subject: Re: Poor performing Oracle Query > .... > ....Ian Skinner wrote: > ....> What would be a good checklist to try and figure out why a query > built > ....by one of our Oracle DBAs runs in about 30 seconds when he runs it > ....through the SQL+ tool in the Oracle development suite? But when that > ....same query is placed in a <cfquery> tag set, it takes 18 minutes to > run! > .... > ....How many records does it return? > .... > ....Jochem > .... > .... > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211461 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
