Can you post the query? That would help alot.
Doug B. ----- Original Message ----- From: "Sicular, Alexander" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, January 05, 2007 7:24 AM Subject: slow query in cf but fast in Sql2k5 management studio. > Hello Gang, > I have a query that is running slow when processed by coldfusion but > fast via the sql2k5 management studio (on the order of 15 to 1). Are > there any connection specific issues between cfmx 6.1 (I know, I know) > and sql2k5 I should be aware of? > > I downloaded the latest jdbc drivers from microsoft and am using them > via the 'other' driver settings when selecting a driver in the data > sources administrator. Just wondering if im missing something obvious or > otherwise. > > Overall, my cf app is working fine against the sql2k5 database. > > Tia, alex > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:265773 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
