> Yes but during that test were those variables being written to at > the same time? I beleive that if you do a read without locking, > and a write occurs or is occuring at the same time, you will have > problems. > > But what if there is no writing? Say you setup a datasource name if > its not defined. Then thats it, it will never be written to again > until the server restarts and application variables are lost. > > In this situation can't you do reads without locking? after the application loaded, there were no additional variables being written, just read. and yes, that was what caused the fatalities. there is a setting in CF Admin that can do the read locks automatically. that is what we're currently using and even under load testing we cannot find any real performance degradation. i know it sounds really bad. i've asked myself over and over "why the #$(*& did allaire implement something that would force me to possibly rewrite everything i've done". to tell you the truth, that's exactly why we'll be moving to JSP/EJB in the next six months -- vendor independence. i can only wonder how many other development companies have or will be moving off ColdFusion because v4.5 was so unstable and questionable. -mike ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.