So James, just this: <cftransaction isolation="SERIALIZABLE">
And problem solved? I will load test as you suggest, but I don't think it should be a problem - inserts are so rare relative to everything else... Thanks! -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, January 09, 2006 1:14 AM To: CF-Talk Subject: Re: Get last inserted ID You can just modify your cftransaction tags to use the serializable isolation level if you want, but do some load testing first because there will be locks-a-plenty if you do... On 1/9/06, Baz <[EMAIL PROTECTED]> wrote: > Thanks for the info guys - all this makes me really sad... I remember > researching this a long, long time ago and was recommended using > cftransaction - so I did - for EVERY insert for all my apps. Now it seems I > have major changes ahead of me... -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:228814 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54