G
Grant Holman
Guest
Hi Could someone please clarify a question I have about how the space in the BI is used. KB S1274 states: "As Bi notes are written serially to the Bi file then clusters can only be re-used serially. This means it only takes one active transaction to remain open for Progress to keep adding new clusters as other users open and close transactions." I read this to mean that while a transaction is open the BI cannot reuse existing clusters and must add new ones to the end, but I think I may be wrong here... I created a new sports database, proserved it and ran two client connections. The first held a lock on a record in a transaction while the second performed sizable DB updates inside one large transaction. I ran the update process repeatedly and although the BI grew to cover the total transaction size it didn't continue to grow for every run (i.e. it must have been reusing existing BI clusters once the BI had reached a certain size.) So am I wrong that a single open transaction always forces creation of new BI clusters?
Continue reading...
Continue reading...