Re: Update big tables !

Posted in 1998

Kurt Wall — 3 Sep 1998 01:22:24 +0500 — source: Informix-list mailing list archive (1991-1998)

<rok.vizintin@mais.si> spake unto the assembled, saying: % I'm using Informix 7.30 and BUFFERED database. % % I want to update very big table and Long transaction error appears. % I usually do in this way: % 1. change database mode to NON LOGGING. This would help, but pray your box doesn't crash. % 2. update a table % 3. chnage database mode to BUFFERED again. % % Is teher any shortcut to do it. I don't know if I would consider it a "shortcut," but you could try breaking your transactions up with COMMIT WORK. % % Thanks % Rok % Kurt