Re: [PHP] Re: mysql transactions/rollback

2001-10-19 Thread Heikki Tuuri
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

[PHP] Re: mysql transactions/rollback

2001-10-18 Thread CC Zona
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

Re: [PHP] Re: mysql transactions/rollback

2001-10-18 Thread Job Miller
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]