OK, well that could cause some performance issues I suppose. I thought (for some reason) that the MySQL default for InnoDB tables was "READ_COMMITTED".
Thanks, --Ferg James Holmes wrote: > 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:239607 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
