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.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
From: Paul Howard <paulhoward@home.com>
>
>We have IDS 7.31 and AIX 4.3
>
>I am being told by my software vendor that I should not fragment tables
>using
>Informix
>fragmentation. They say that it would be better for me to optimize my
>system by
>spanning dbspaces across multiple disks and letting the hardware fragment
>the
>table.
>
>This is contrary to my experince and schooling. Can anyone tell me how much
>merit
>this
>statement of my software vendor has?
OLTP:
How much data have you got? Your software vendor is being time- and
cost-effective (lazy). I can *always* outperform RAID eventually with manual
placement, but do you want to pay me for six months while I do it? And keep
paying me to keep it optimised? :-)
If you haven't got tons of data, I'd go with Informix fragmentation. If you
have got tons of data, go with RAID10.
DSS:
Your software vendor is dumb. If you don't fragment, you can't use PDQ. 8-)
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
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.