Re: Disk Storage

S.Sathish wrote: > > hi, > The chapter on performance tuning in the book Informix > Unleashed,says 'store the dbspaces which are prime real estate near the > center of the disk' > Now, does that mean important/valuable data is to be stored near the > centers of the disk or the most frequently accessed data? > Also, can we specify as to where the dbspace is to be located? > how to position it near the center of the disk.Is it OS dependent ? > Any ideas as to how it could be done in SCO. > Thanx, > ****************************************************************************** > S.Sathish > email :ssathish@cmcbang.ernet.in > ****************************************************************************** The rule of thumb is to put the most frequently accessed data towards the center of disk to minimize head movement. It is entirely dependent on how the disk is partitioned, block size, number of heads, and such. The way you achieve the data localization is by intellingently creating chunks, and offsets to chunks. Good luck, Arun