Re: What determines system Page Size?

Hey Mickey! Have you had a chance to check out those Circle K's yet? Well, seems like I actually have the answer to this. Believe it or not, our friends at tech support answered this. Basically, the OS's page size is somewhat irrevelant, at least with ODS. The page/buffer size is hard-coded to 2K. Depending upon the system, your IO transfer size can be as high as 8K (as is the case with Solaris 2.5.1 - I believe). Yes, you heard correctly, the internal page size is hard coded. Guess at one time you could set in ONCONFIG but not any more. We thought this to be rather stupid. Especially, when we are loading our statement blobs. The blobs that fit nicely on a page were loading at about 1/6th of a second, those that spanned load up to 1.1 seconds per. We thought, well we should just adjust the internal page size right...WRONG...so we live with it. 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 > -- > > _____________________________________________________________________________ > Mickey Mestel mickm@netcom.com > > -on a beach in thailand to a beautiful, stoned, norwegian woman: > "..yeah, it's just another foreign country without ice." > ----------------------------------------------------------------------------- -- Bryan Hughes Chief Systems Architect - Transaction Systems Wells Fargo Bank bryanhughes@earthlink.net hughesb@wellsfargo.com "I wonder how much deeper the ocean would be without sponges?"