AFIAK all pages will access CDATA and CGLOBAL as these are the client varibles data tables... So if you have client variables turned on and the datasource going to that database then all page requests will update them...
HTH Mike -----Original Message----- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 18:52 To: CF-Talk Subject: CGLOBAL & CDATA-SQL 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
