I am currently reviewing a ColdFusion site architecture. <br><br>The datasource name for the entire application is stored as an application level variable and all queries are subsequently enclosed within a cflock tag. At the moment the tags have the default Exclusive lock so the first thing to do would seem to be to set the locks to ReadOnly. <br><br>However I am wondering if a simple page level variable set in the Application.cfm file would be more appropriate, I realise the performance hit for many initialisations, but is this hit any worse than than that for setting all the ReadOnly cflocks (there are many queries being run throughout the site).<br><br>Any thoughts or comments would be much appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use of Cflock (performance issues)
- Thread starter Thrud
- Start date
Similar threads
- Locked
- Question