Well we have more information on the problem. The query that was running fairly well at 30 seconds or so was being run against a validation database where the data is static.
The query that was performing poorly at 18 minutes was being run against the production server where the data is very active. Apparently every time data was being added to the main tables, this query would be started over. So depending on the traffic sometime it performs relatively well other times it performs very poorly. -------------- Ian Skinner Web Programmer BloodSource 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:211464 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
