Does anyone know what pages process the CDATA and CGLOBAL queries when you have these values stored in a DB. None of the select statments have NOLOCK's on them after sending out around 450,000 email this week, those tables are invoking an awful lot of lock:aquires and lock:release on my SQL server. It isn't killing it, but there is definatley a performance hit there. They are not SP's already looked there, they must be hardcoded queries, that at least utilize the sp_executesql (thankgod). Any help or further info would be great.
Thank you, Christian Watt Webmaster ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
