We're working on the SP version to see if that help. No it does not take nearly as long to run in SQLPlus, about 20 seconds, versus 18 minutes when run from a CF page.
-------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning ....-----Original Message----- ....From: Aaron Rouse [mailto:[EMAIL PROTECTED] ....Sent: Friday, July 08, 2005 2:50 PM ....To: CF-Talk ....Subject: Re: Poor performing Oracle Query .... ....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 ....> .... ....> .... ....> ....> .... .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211462 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
