Quoting from page 17-10 of the IBM Informix Dynamic Server Administrator's
Guide (IDS 9.4 on Solaris 8) -- "A data page is read from either the primary
chunk or the mirrored chunk, depending on which half of the chunk includes
the address of the data page.". If the disks containing the primary chunk is
faster than the mirrors, is there a way to control the placement of tables
that will optimize the overall performance?
If my chunks are large enough to accommodate all the data in the first half,
does it mean the split reads will not be active? The fine manual does not
talk about these details. Would someone please care to shed some light on
the split read behavior? Thanks....