Re: Max Chunk Size

Posted in 1997

Koen Van der Elst — Thu, 9 Oct 1997 22:55:03 +0200 — source: Informix-list mailing list archive (1991-1998)

Spreading your db's across chunks gives you a performance advantage. Because Informix can do A LOT of things in parallel using its multi-threaded achitecture, most operations will go A LOT faster. Check your Administrators Guides and the Performance Guide. Watch out with Sun's array controller. The software that comes with it (vxva it think it is called) does not allow you to partition you disks. Eg: Say you have 10 disk of 4GB and you configure them using RAID1 (forget RAID5 when using Informix). You will end up with 4 logical volumes of 4 GB and no possibility to partition them! Because the maximum chunck size in Informix is 2 GB, you have a problem! Solstice does not have this problem but is does not support the array controller. Bummer. One nice thing though: that machine literaly flies using Informix. I've been working with an Enterprise Server 3000 and it kicks ass! K.