AUTOCOMMIT v DBI default

Honza Pazdziora adelton na informatics.muni.cz
Úterý Prosinec 4 18:11:15 MET 2001


On Tue, Dec 04, 2001 at 05:43:31PM +0100, Lubo? Polednieek wrote:
> Kolegove odbornici.
> Pouzivam BDI - ODBC pro pristup k BD na AS400 z NT stroju.

DBI.

> Pri otevreni conection pres odbc je nastaveno  neco parametru defailtne.
> Protoze jsem dospel k zaveru ze si AS400 dela asi neustale commity po kazdem cyklicke INSERT do BD2
> chtel bych to potlacit protoze to neuveritelne zdrzuje insert proces.
> Dle BDI dokumentace je parametr autocomit pri otevreni nastaven na defautl hodnotu 
> Na jakou ?

         The `AutoCommit' and `PrintError' attributes for each
         connection default to "on". (See the AutoCommitand

> Drha otazka :
> Autocommit=>1 znamena co ? Ze po kzaden Insert se provede commit ?

         If `AutoCommit' is on, then the effect is the same as if
         the DBI called `commit' automatically after every
         successful database operation. In other words, calling

Tedy nejen po kazdem insertu.

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, DBD::XBase.
------------------------------------------------------------------------


Další informace o konferenci Perl