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 SkillPath Seminars ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
