> the effect that this approach might provide a very slight performance > advantage in high-traffic environments, I really couldn't find any other > reason to explain why some CF coders routinely use this approach.
because it tells sql server NOT to return row count data, it saves trips from the server. it shaves ms off of sql operations, especially ones that are banging around on the server & maybe returning multiple resultsets. for this reason its often recommended for large/complex SP. it also prevents cf from thinking row counts are valid resultsets, for instance its use in the case of returning @@IDENTITY. ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
