Re: autocommit and transactions

From: "Sally Sally" <dedeb17(at)hotmail(dot)com>

> Using perl DBI I recently read that if autocommit is turned on, it does a
> commit after every transaction. I wanted to confirm if this also applies
to
> select statements.

in fact, it wraps every statement that is not aleady in a transaction,
into one.

> When I'm loading data, I need to do a select before inserting a new row
and
> I don't want to commit after the select because it's unnecessary. So I am
> thinking of turning off the autocommit. Any thoughts?

$dbh->begin_work;
<your statements here>
...
$dbh->commit;

gnari