MySQL has multiple different storage engines that all reside underneath the common MySQL interface. Some of the storage engines (innoDB and BDB) support transactions, the rest don't. If yuo don't want to use a transactional engine, you can duplicate the functionality with table locks (on any engine), thought that obviously has a great effect on concurrency.
barneyb > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 16, 2003 1:51 PM > To: CF-Talk > Subject: MySQL ? > > > i havent used this db before but im gunna do a site where they want it if > possible. > > I have never really used it before and my only concern is i remember > something about it no supporting transactions. > > the part on the site i will be concerned with is there will be a small > auction section & i'm curious to how that can be handled with MySQL. > mostly were ppl are bidding at the last second. > can I use cftransaction with MySQL i guess is my question, if not how do > you guys do this with this db? > > ty > dave > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 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
