> Does anyone have any information on changing the Isolation Level on MS > SQL Server 2000 as referenced in: > http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenote > s_mx.html#perf
Everyone, please be very careful about this! You should understand precisely what the implications are of changing your isolation level to READ UNCOMMITTED before you do this, as it allows every possible negative phenomenon to occur in your transactions, including dirty reads, non-repeatable reads, and phantom rows. Basically, you are telling all your transactions to neither set nor pay any attention to any locks that the locking engine would normally set to maintain data consistency. Try this under load on transactions that rely on data states in related tables and you may end up with bad data, but the worst part is that you may not know it is bad data until way later when inventory runs out during shipping fulfillment or the books no longer balance. If any of you are in a bind and you need a rundown on the details of this, feel free to give me a call next week and I'll be happy to spend some time with you. Break's over for me; gotta get back! :) Respectfully, Adam Phillip Churvis Advanced Intensive ColdFusion MX Training http://www.ColdFusionTraining.com E-mail: [EMAIL PROTECTED] Phone: 770-446-8866 Team Macromedia Volunteer for ColdFusion http://www.macromedia.com/support/forums/team_macromedia/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
