Re: [PHP] Re: mysql transactions/rollback
Hi! Job Miller wrote in message <[EMAIL PROTECTED]>... >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 <[EMAIL PROTECTED]> wrote: >> In article >> ><[EMAIL PROTECTED]>, >> [EMAIL PROTECTED] (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: >> [EMAIL PROTECTED] >> For additional commands, e-mail: >> [EMAIL PROTECTED] >> To contact the list administrators, e-mail: >> [EMAIL PROTECTED] >> > > >__ >Do You Yahoo!? >Make a great connection at Yahoo! Personals. >http://personals.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Re: mysql transactions/rollback
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. is it worth it? instead of my previously suggested method of handling it? or is there something better? --- CC Zona <[EMAIL PROTECTED]> wrote: > In article > <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] (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: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Re: mysql transactions/rollback
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]