On Thu, Sep 11, 2003 at 02:30:59PM +1000, Daniel Rossi wrote: > > when is it a good time to do the set auto commit=0 , while doing the > update or insert query or sometime before that in the application ?
Whenever you need explicit transactions. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 165,074,846 queries (451/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]