> 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 Get the mailserver that powers this list at http://www.coolfusion.com
