AFAIK the query is made by the server itself and so you cannot change the query that it calls...
-----Original Message----- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:04 To: CF-Talk Subject: RE: CGLOBAL & CDATA-SQL Yes, I realize that, that is why I see a performance hit, what I want to know is what CF Server page is called to invoke the query so that I can update it and include no locks on them. -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:45 PM To: CF-Talk Subject: RE: CGLOBAL & CDATA-SQL 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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