We have a project here where they are using CF5/Oracle and make some SP calls that "run big queries" They said that when they make one of the SP calls the whole server will choke and stop responding to requests until the SP has finished running which takes upwards of 15 minutes. If they take the query out of the SP and put it into a CFQUERY then it no longer chokes, it is my understanding the query still takes a long time to run this way or just through SQLPlus. It has been tried using ODBC and native connection data sources and with connection pooling enabled. Is this typical for all resrouces to just get consumed for SPs and not for cfqueries or is there maybe something I could pass onto them to check?
-- Aaron Rouse http://www.happyhacker.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238598 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
