Yep, I wrote that section, and there are two things worth noting about it: 1) At the time it was written, which was when 6.0 was still in Beta, calling CFTRANSACTION without explicitly declaring begin, commit, and rollback did bring performance to a crawl. I mean it was *really* bad. I believe Dave Watts is correct that it's probably been fixed since then, but I still like to be explicit in my coding anyway, so I still use this technique when I'm forced to control a transaction from within ColdFusion (which is a last resort).
2) The code example shown isn't the way we do things anymore. There is a better way to handle it without all the extra flag-and-test code. The way I do it now is to just call action=commit after the final cfquery inside the cftry, and inside the cfcatch block I just call action=rollback. This is because cftry will immediately transfer program flow to the applicable cfcatch block, bypassing all other code in the block, so you really don't need to set a flag and test it. One of those V-8 moments you get *after* your book goes to press ;) Respectfully, Adam Phillip Churvis Certified Advanced ColdFusion MX 7 Developer http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, February 16, 2006 11:43 AM Subject: RE: CFC & cftransaction > > Wasn't the ColdFusion MX Bible written by Charlie Arehart > > from New Atlanta (the makers of BlueDragon)? > > > > Mayby he will share with the list why he stated that omitting > > BEGIN, COMMIT, and ROLLBACK will bring CFMX to a slow crawl. > > I suspect that the portion in question was written by Adam and/or David > Churvis. I very much respect their opinions, but I suspect that this has > been resolved with newer database drivers. Since CFMX first came out, there > have been many, many database driver releases. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232486 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
