> 1. Is there a limit to how many queries can be within > cftransaction tags?
Not really. I suppose there are some physical limitations, but you're unlikely to hit them. However, you want transactions to be as short and quick as possible, because they're typically enforced using locks. So, if you have really long transactions, you will lock other users from the database for a long time. This is a big problem, especially with web applications because they're typically intended for use by multiple concurrent users. > 2. If all the inserts/updates are to one table, will the > table be locked or the whole database? This depends on the specific database in question. Typically not even the entire table will be locked, only the rows which you're reading or writing. I believe that MS Access locks the entire table whenever it's read or written to. > 3. Does the transaction tag slow the process down? Yes, of course. Data integrity must be balanced against performance. If you're concerned enough about data integrity to require transactions, you're typically willing to sacrifice performance accordingly. > 4. Does MS Access support the concept of transactions or do > I have to wait until I switch the database over to MS sql. Yes, Access supports transactions. However, because of the granularity of locking within Access, those transactions may take longer to run, all other things being equal. (Of course, all other things are not equal, and MS SQL Server is typically going to outperform Access with or without locking or transactions.) > 5. Does the transaction process notify of success or failure? Not exactly, but if a transaction fails, that typically means that one of the queries contained within the transaction failed. This will still throw an error as it would if you didn't have CFTRANSACTION tags around them all. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220620 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
