G
gus
Guest
you are partly right. not /always/. transactions that don't actually do anything are optimized away in both the 4GL runtime and in the database itself. that makes it harder to see what is happening. when there is an active transaction that has written a transaction begin to the bi file, the bi space /from that point forward/ cannot be reused until the transaction end. this is becuase the transaction might have to be rolled back and if we overwrote any of its notes, that would be impossible. the trnasaction manager does not know which bi clusters might have been used by a given transaction so we assume all after the transaction begin. clusters earlier than the earliest active transaction begin can be reused. > On Nov 25, 2015, at 8:30 AM, Grant Holman wrote: > > Update from Progress Community [https://community.progress.com/] > > Grant Holman [https://community.progress.com/members/gpholman] > > 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? > > View online [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21608] > > You received this notification because you subscribed to the forum. To stop receiving updates from only this thread, go here [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21608/mute]. > > Flag [https://community.progress.com/community_groups/openedge_rdbms/f/18/t/21608?AbuseContentId=7dde597f-304f-43dc-8dbb-d90920d01163&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true] this post as spam/abuse.
Continue reading...
Continue reading...