The client variables are retrieved during the processing of CFAPPLICATION. (clientmanagement="Yes" clientstorage="MyClients")
The actual process that runs the query is "Under the Hood". HTH Regards, Rob Rusher --- Christian Watt <[EMAIL PROTECTED]> wrote: > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
