imp commit=n and rbs

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 25 Apr 2003 09:12:30 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703994AD3@lnewton.leeds.lfs.co.uk>

Morning Joel,

commit=y means that a commit is done whenever a buffer's worth of rows are written to a table. Unless the table being imported has a LONG column, in which case you get a commit for each row in that table.

commit=n means that a commit takes place at the end of each table. You will have the index builds as well I think, constraints etc - all of which would have to be rolledback in case of a failure.

I use commit=y and a buffer of 1024000 or 2048000 bytes when I import depending on the size of the dump file.

Cheers,
Norm.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Fri Apr 25 2003 - 03:12:30 CDT