I'm not sure. As in the classic game of "phone," I probably have this wrong. But as I understood the explanation, the DBA thought the query was being restarted when new data was added to the underlying tables. It seemed odd to me as well, but I'm just the web programmer.
Any the plan currently is to create views of this data that are updated nightly during a slow period. Then use these views to create the summation data. -------------- 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: Saturday, July 09, 2005 1:44 AM ....To: CF-Talk ....Subject: Re: Poor performing Oracle Query .... ....Ian Skinner wrote: ....> 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. .... ....That sounds rather vague. Does the DBA mean the database was ....running out of rollback segments and instead of just returning an ....error was somehow retrying the query? .... ....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:211546 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
