Re: What determines system Page Size?

In article <mickmEq2yKI.Eo5@netcom.com>, mickm@netcom.com (Mickey Mestel) wrote: > > hi all, > > what actually determines the page or buffer size that the engine > uses? i know it is directly related to the os and hardware(?). i thought > that it had to do with the largest block size that could be transferred from > a peripheral. so if the largest single transfer size that the os can handle > from the disk is 2k, then that is the page size. > > am i anywhere close? enquiring minds want to know. > > mickm > -- Most database mangement systems implement a fixed page size of 2K. This is just a design decision - it allows reasonably sized rows, will accomodate a fair number of "average" sized keys and fits well onto most disk track sizes etc. Physical transfer sizes can usually be much bigger - 32kb is quite usual. -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading