Is it true that the SQL will perform better if you cfqp any static values too? So:
WHERE <cfqp value="1"> over: WHERE id = 1 Adrian > -----Original Message----- > From: Dave Watts [mailto:dwa...@figleaf.com] > Sent: 19 January 2009 16:31 > To: cf-talk > Subject: Re: Coldfusion killed my query? > > > 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!! > > While you're doing that, you might want to make your lists with > CFQUERYPARAM too. > > Where LogClass.Name In ( > > 'org.thinkblue.TransferComplete', > > 'org.openobex.Error.ConnectionRefused', > > 'org.openobex.Error.Forbidden', > > 'org.openobex.Error.NotAuthorized', > > 'org.openobex.Error.ConnectionTimeout' > ) > > would be > > Where LogClass.Name In ( > > <cfqueryparam ... list="yes" > value="org.thinkblue.TransferComplete,org.openobex.Error.ConnectionRefu > sed,..."> > ) > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:318173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
