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]

Reply via email to