Seems fairly impossible to me to really emulate transactions on a non-transactional db. Even if you develop a system where you : a. collect all queries untill the end and then perform them in 1 block b. keep your own logs of the queries and be able to roll them back in case of error even then it will not be a real transaction, because for example : - a server-crash whilest doing the 1-block-query will corrupt the database - same for the roll back you have written - you don't have isolation levels, so queries will read wrong data - ...
Switch to InnoDB is my advice :) B. -----Original Message----- From: Pierre Baridon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 08:11 To: smart chandar; [EMAIL PROTECTED] Subject: Re: Implementing commit,transaction in isam table type why not using innodb tables ? smart chandar wrote: > I am using Mysql Db that contains Isam table types,I > am developing a project > that is using interrelated tables,unfortunatily isam > table type doesn't support > the commit and transaction,but i should implement > that,can anyone give a > logic for that > > thanks in advance > > with regards > chandar > > > __________________________________________________ > Do You Yahoo!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php