Forum Post: Re: Records Per Block Details

  • Thread starter Thread starter gus
  • Start date Start date
Status
Not open for further replies.
G

gus

Guest
right. however, there are various circumstances in which fewer records will be stored in a block. among these are: 0) there is a rowid placeholder for a previously deleted record and the offending transaction has not committed. 1) there is insufficient free space > On Nov 18, 2015, at 11:49 AM, George Potemkin wrote: > > Update from Progress Community [https://community.progress.com/] > > George Potemkin [https://community.progress.com/members/georgep12] > >> Binary analyse of blocks on the file system gives a result that when you define 32, 64, 256 (this is what I tested) Records/Block in the .st file of the database, always one record less is saved in the block in reality. So you get only 31 Records in a block with 32 records per block. > > Use dbrpr/13. Display Block Contents > > You will see that data block can store exactly up to RPB records. > > View online [https://community.progress.com/community_groups/openedge_general/f/26/p/21180/75443#75443] > > You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here [https://community.progress.com/community_groups/openedge_general/f/26/t/21180/mute]. > > Flag [https://community.progress.com/community_groups/openedge_general/f/26/p/21180/75443?AbuseContentId=94913778-3cb2-4587-a827-5e7edd3496f8&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true] this post as spam/abuse.

Continue reading...
 
Status
Not open for further replies.
Back
Top