Holy cow-- 5000 records. Are those two queries against separat data sources? That's something I would try my darndest to get accomplished on the SQL server side. I imagine it would perform MUCH better as a join than to bring the whole first query back and then make a second. Of course, you may not have that option... ~Brad -------- Original Message -------- Subject: cfqueryparam - couple ofquestions from a problem that occured today... From: Les Mizzell <[EMAIL PROTECTED]> Date: Mon, September 15, 2008 3:36 pm To: CF-Talk <[email protected]>
My original query code below, which has been running for months with no error, suddenly start throwing an unspecified database error today, plus actually timed out once, and the server reset in the middle of the query another time: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
