I got zero response on cfdj so I figured I'd post here. Perhaps someone here can help. I've got a very odd problem. Running mx on linux redhad 7.2 against oracle 8.1.5. Soon to be 8.1.7. Were replacing an application written in omnis which is annoyingly blazingly fast-compiled and talking directly to the db.
Its got some big queries that we've replicated in cf where all the variables are cfqueryparamed. Heres the problem. When I call the same query with the cfqueryparams it takes between 60 and 90 seconds on average. When I call it without the cfqueryparams, it takes 20 seconds the first time and then single digits thereafter for the same call. Now the omnis application also binds its variables and also returns its recordsets in single digit times. Then we write the same query in a stored procedure- with and without binding. And both are almost the same in the single digit times. So, why on earth is coldfusion taking so long to return a query with bind variables? Anybody seen this? Help! DRE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
