really. tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 9:51 AM To: CF-Talk Subject: RE: <cfquery syntax > faster than the raw data being in there? Yes. > how can that be? Because, by separating values from the rest of the SQL, the database won't have to do that for you, and may be able to use a cached execution plan if one exists. > that's just one more tag that cfserver has to interpret > process etc...albeit a millisecond or less, enough of > them could be slower? > > im not sure I get that logic? It doesn't make your CF code, specifically, faster - it makes your database respond faster. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm