> > 1. no cfqueryparam all columns > Time=31ms, Records=210 > > 2. no cfqueryparam no txt columns > Time=31ms, Records=210 > > 3. cfqueryparam all columns > Time=17297ms, Records=210 > > 4. cfqueryparam no txt columns > Time=16359ms, Records=210 > > > turns out the cfqueryparam is giving me the problem here. any > thoughts? i use cfqueryparam mostly everywhere as a rule and never ran > into this problem. like, why here, why now?
Are you using any 'N' fields in your database? Have you set sendStringParametersAsUnicode in your JDBC URL? If not, set it to false and try again. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:265823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
