Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Albert wisse wrote:
>
> I have to decide to mirror the indexes yes or no. If I don't mirror
> the indexes then I can use two disks for the indexes to increase the
> performance.
> The thought behind is that if a disk with indexes chrashes then it is
> simple to regenerate
> the indexes in another dbspace.
> I this approch valid or is it better to miror the index disk/dbspace
> and so why.
Performance may be a wash since the engine can read/write from both
sides of the mirror simutaneously reading two independent index pages
for the same gain you hope to get from fragmenting the indexes. You'll
have to experiment, but I suspect that is what you will find and the
safety of mirroring for your indexes which are at greater risk from
crashes NOT related to disks than data pages are (due to the intimate
linkages between index pages and between them and data pages) far
outweighs any possible performance gain.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.