Yes- always specifying types is definitely a best practice. I haven't noticed any QoQ performance degradation in CFMX 7 at all... and I've been doing a lot of building the queries from scratch in my testing.
~Simon Simon Horwith CIO, AboutWeb - http://www.aboutweb.com Editor-in-Chief, ColdFusion Developers Journal Member of Team Macromedia Macromedia Certified Master Instructor Blog - http://www.horwith.com James Holmes wrote: >That sounds like a new "best practice" - always specify a columntypelist for >CF7 queryNew() calls. > >-----Original Message----- >From: Jay McEntire [mailto:[EMAIL PROTECTED] >Sent: Tuesday, 8 February 2005 12:30 >To: CF-Talk >Subject: Re: CF MX Performance Hit -- Amy I the first to notice? QoQ > >LOL, i found out what it was. > >You can specify 'columntypelist' in the queryNew function. Its optional, >but not specifying any data type put a significant increase in load time. > >Insteresting.....good to know. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193537 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54