Suggestionfor Firebird: Use NO_AUTO_UNDO option for bulk inserts

Database components for Delphi, FreePascal/Lazarus, Kylix, C++ Builder

Brought to you by: egonhugeist, markdaems, marsupilami79, miseeger

#38 Suggestionfor Firebird: Use NO_AUTO_UNDO option for bulk inserts

Milestone: Unknown

Status: open

Owner: nobody

Labels: None

Updated: 2021-08-27

Created: 2019-10-09

Creator: marsupilami79

Private: No

from https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/

Use NO_AUTO_UNDO option for bulk inserts/updates
If you are running many DML (Update/Insert/Delete) commands in the frames of the same transaction, Firebird merges undo-log of each command with undo-log of the transaction. To speed up bulk DML operations start the transaction with «NO AUTO UNDO» option, in order to do not merge undo-logs of each command with the transaction's undo-log

I suggest we use that for bulk data management.

Discussion

marsupilami79 - 2021-08-27

Ticket moved from /p/zeoslib/tickets/377/

Can't be converted:

_type:
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Suggestionfor Firebird: Use NO_AUTO_UNDO option for bulk inserts

Database components for Delphi, FreePascal/Lazarus, Kylix, C++ Builder

Milestone

Searches

Help

#38 Suggestionfor Firebird: Use NO_AUTO_UNDO option for bulk inserts

Discussion