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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211488 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
