Does oracle have something similar to "with (nolock)" that SQL server has? This would just run the query and not wait if it can get a lock on all the tables..
-----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, July 08, 2005 7:15 PM To: CF-Talk Subject: RE: Poor performing Oracle Query 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 ..... ..... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211470 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
