Hello,
just for understanding: Why is the bi file size growing when doing big transactions with no-integrity flag?
For example importing a schema delta file with a new index on a huge table.
Thank you
Regards
Peter
If you are thinking that -i = "no bi notes" then you have fallen victim to mythology.
The bi notes are created, even with -i, because the 4gl may need to UNDO a transaction.
BTW -- you get essentially identical performance benefits using -r and it is less fatal if something goes wrong. Neither should be used without first making a backup but if you are going to do something like that -r is safer.
Progress creates the same recovery notes and the same number of the recovery notes with/without no-integrity flag.
You need the -ii parameter but it's not (yet?) implemented. ;-)
No-integrity (-i) doesn't mean "no BI notes". While crash recovery is not possible with -i, transaction undo is; so BI notes must still be written.
A better practice when adding an index to a very large table is to add it inactive and then activate or build it after the fact. The schema update will then be very quick and will not grow the BI file.
If you are thinking that -i = "no bi notes" then you have fallen victim to mythology.
The bi notes are created, even with -i, because the 4gl may need to UNDO a transaction.
BTW -- you get essentially identical performance benefits using -r and it is less fatal if something goes wrong. Neither should be used without first making a backup but if you are going to do something like that -r is safer.
Thank you all for the quick replies.
All answers answered the question.
Regards
Peter