> Is there much of a processing cost to this? If not why > wouldn't I surround all my associated query blocks with > the cftransaction tags.
Nothing is free, including CFTRANSACTION. When you designate a set of queries as a transaction, the database has to take special actions which typically limit what other transactions can do while your transaction is running. (Note that any single query is a transaction - it'll either succeed or fail in its entirety.) So, if you unnecessarily chain a bunch of queries together within a single transaction, that may cause a significant bottleneck. That being said, if you do have associated queries, and they do need to be treated as a single, atomic database operation, you'll need to group them together within a transaction. If possible, you might do this within a stored procedure, which will generally run faster. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
