Re: Page Sizes on Sun centre 1000 4k - Informix says 2k.

In article <42gsm0$o79@status.gen.nz>, Peter Tashkoff <ptash@iconz.co.nz> wrote: >When I installed 7.10 to our sprac 1000 the page size was set at 2k >with lots of the usual warnings not to mess with it; in fact you can't >because it's not in the onconfig file anymore. >the point of puzzlement is that the unix gurus insist that the page >size on a sparc 1000 (sol 2.4) is 4k. >informix runs fine - but the sun is a little shakey at times? >Am i missing something?.... The Informix page size has nothing to do with the hardware page size. Its just the min I/O size and allocation size. Having it be smaller allows for a bit better buffer cache utilization, but 2K vs 4K doesn't seem to make much differenece. If you're doing large scans you will be reading in larger blocks anyway. -jrg -- internet jrg@galloway.sj.ca.us John R. Galloway, Jr 795 Beaver Creek Way applelink D3413 CEO...receptionist San Jose, CA 95133 Galloway Research (408) 259-2490 v (408) 259-5058 f