What the heck?! Never would have guessed that. You changed cf_sql_type on which queryparam from what to what?
On Mon, Jan 19, 2009 at 7:55 AM, Robert Rawlins < robert.rawl...@thinkbluemedia.co.uk> wrote: > 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:318161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4