[progress Communities] [progress Openedge Abl] Forum Post: Re: Block Size Os Vs Db

  • Thread starter Thread starter mfurgal
  • Start date Start date
Status
Not open for further replies.
M

mfurgal

Guest
The difference between 4K and 8k by itself is not much, but the difference in a 3 level index vs a 4 level index is very real, like as much as 20%. So a larger block size allows more index information to be stuffed into a database block, hence allowing for a much better chance of having a 3 level index for the same index data vs a small database block. For me this is the reason to make an 8k DB block size Mike

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