Re: DB_BLOCK_SIZE=4096 in NT????

   It is my understanding that NT uses a consistemt blocksize of 4K (8sectors / cluster). I may be wrong...

   BTW: When creating a database on UNIX, I would like to be able to determine the OS blocksize for myself rather that asking the SysAdmin. Is there an easy "generic" way of doing so?

>you can only set (change) DB_BLOCKSIZE when you create a new
 database.<BR>
>Changing DB_BLOCKSIZE of an existing one won't work. Blocksize of
 4096<BR>
>will work. Why not? But setting blocksize must be well thought about.<BR>
>Normal NT-Blocksize will be 2048. In case your db's rows are large<BR>
>enough to keep them better in 4096 blocks then change blocksize of
 new<BR>
>db. We changed blocksize to 8192 - the stripe size of our RAID5.<BR>
Received on Tue Aug 05 1997 - 00:00:00 CDT