But doesn't that fall under reverse engineering? ;)
-----Original Message----- From: Christian Watt [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:59 To: CF-Talk Subject: RE: CGLOBAL & CDATA-SQL Sure you can...It is quite simple to decrypt the server pages and update them, as long as the query is in fact called from a server cfm page (which I am willing to bet that it is). I just would like to know if anyone has any idea which page, or at least which directory it is in so that I can do so. Will save a lot of time searching for it. Christian -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 1:17 PM To: CF-Talk Subject: RE: CGLOBAL & CDATA-SQL 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
