Re: SE and big databases or RAID

Posted in 1996

Billy Wheeler — 20 Feb 1996 01:33:05 -0500 — source: Informix-list mailing list archive (1991-1998)

Use Online, stupid! :) >I know this is will generate remarks like "Use Online, stupid!", but... >I have a customer running SE for the obvious cost savings over Online. 1. It should be fine. 2. RAID should be fine. 3. If (when) you _do_ upgrade to OnLine, chuck out the RAID. 4. Watch your indexes, UPDATE STATISTICS often, consider ALTER INDEX TO CLUSTER every once in a while for the bigger tables. All IMHO, YMMV, etc. :) Good luck... -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 i'm schizophrenic: my opinions are not those of me -----------------------------------------------------------------------------