> 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.
Those tables are used by CF when your application uses Client variables, and stores those variables within a database. In this situation, you're going to have a read for each page, and a write on any page that sets a client variable. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
