Very good point with about the CFIDE. Considering that, there is a very good chance that it is a dll. Then I maybe unable to change this at the query level, unless there is someone out there that knows of a way to turn this off the the SQL Server level, I have yet to find one.
As for reverse engineering??? Call it as you may. I see it as improving the performance, something that Macromedia may like. Of course I am sure that I am truely suppose to create my own app, but then why reinvent the wheel, isn't that what CF is all about anyway, not doubling up the work. Of course in no way would I try to profit from this and any warranty would be voided if it was discovered that I did change something like this, but then what happens to people that can not remember the Admin password and change the login checking page to not check so they can get in and reset it??? Is that considered reverse engineering as well, or that acceptable? Christian -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 1:59 PM To: CF-Talk Subject: RE: CGLOBAL & CDATA-SQL I also doubt that its an encrypted page as you can remove the CFIDE files... Thus it must be called from the bin directory which means the server itself -----Original Message----- From: Mike Townend [mailto:[EMAIL PROTECTED]] Sent: 14 November 2001 19:54 To: CF-Talk Subject: RE: CGLOBAL & CDATA-SQL 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
