Re: Re: mysql transactions/rollback

Hi! Job Miller wrote in message <20011018221811.44160.qmail@web10008.mail.yahoo.com>... >yes, thank you though. >not in MyISAM tables, which is what mine are, and >again according the manual, you slow things down >significantly for transaction support. Transactional InnoDB tables are actually faster in many simple benchmarks than MyISAM. Set innodb_flush_log_at_trx_commit=0 to avoid disk write at each commit. See benchmarks at http://www.innodb.com/bench.html >is it worth it? instead of my previously suggested >method of handling it? or is there something better? Regards, Heikki Innobase Oy >--- CC Zona <cczona@nospam.invalid> wrote: >> In article >> ><20011018201248.82069.qmail@web10002.mail.yahoo.com>, >> jobmiller@yahoo.com (Job Miller) wrote: >> >> > without save points and rollback what is the best >> way >> > to replace all records for a user that might have >> been >> > edited with their new values. >> >> To clarify: are you aware that MySQL does have >> transaction support >> available, or is using it not an option for you >> here? >> >> -- >> CC >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: >> php-general-unsubscribe@lists.php.net >> For additional commands, e-mail: >> php-general-help@lists.php.net >> To contact the list administrators, e-mail: >> php-list-admin@lists.php.net >> > > >__________________________________________________ >Do You Yahoo!? >Make a great connection at Yahoo! Personals. >http://personals.yahoo.com