Hello Guys, Thank you all for your ideas. After speaking with [Justice] over on the IRC channel I removed the <cfqueryparam /> and found it ran smooth as silk. Seems that there was some form of datatype mismatch going on, after changing the cf_sql_type on the queryparam we've got it running at proper speed again!!
Thanks for your suggestions. Rob >Another thing to try: put the query in a sproc and call it with >cfstoredproc. Theoretically, modern SQL Server has made it so that cfquery >(ad-hoc) is as fast as cfstoredproc...but...maybe... > >Let us know... > >On Mon, Jan 19, 2009 at 7:17 AM, Al Musella, DPM ><muse...@virtualtrials.com>wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4