> Depends on your database. I believe SQL Server will allow > multiple writes while Oracle locks the table(s) on writes.
Neither SQL Server nor Oracle will, by default, allow multiple concurrent writes to the same data. Neither locks the entire table during a write by default, either. Both databases lock much smaller units, by default - rows or pages, for example. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists