Ryan, I'd be interested to know if specifying the maxlength attribute in the <cfqueryparam /> tag would have resolved the issue. Did you try specifying the maxlength as "36"?
-Dan >-----Original Message----- >From: Ryan Emerle [mailto:[EMAIL PROTECTED] >Sent: Tuesday, January 02, 2007 1:42 PM >To: CF-Talk >Subject: Re: cfqueryparam DECREASES performance? > >I've had problems due to the general way in which CF handles preparing >the statement. If I recall correctly (it's been a while) I had a >table with 15 million rows where the primary key was a varchar(36). >Because CF uses a generic type of nvarchar(4000) (i believe), the >server would choke as it performed the conversion. > >By changing it to a simple statement, queries decreased from 2 minutes >to milliseconds. > >-- >Ryan Emerle >------------------------------------ >Query2Excel - Write Excel files from ColdFusion >http://www.emerle.net/programming/display.cfm/t/cfx_query2excel >------------------------------------ >Excel2Query - Read Excel files from ColdFusion >http://www.emerle.net/programming/display.cfm/t/cfx_excel2query > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265487 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
