From: http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000346.htm
"If you do not specify a value for the isolation attribute, ColdFusion uses the default isolation level for the associated database." For MySQL InnoDB tables, repeatable_read is the default isolation level: http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-isolation.html On 5/4/06, Snake <[EMAIL PROTECTED]> wrote: > What type of isolation are you using in your CFTRANSACTION, if the answer is > none, then you are using SERIALIZABLE by default, which is the highest level > and slowest performance. > This means nothing else can read or write the locked table or rows until the > transaction block has finished and can thus result in the problem you are > having. > If you have other areas of the site that need to read that that data, then > you should use "READ_COMMITTED" isloation. > I would suggest you read the cfdocs and fully understand the use of > cftransaction and isolation levels. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239578 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
