Re: A DBA philosopical question

rcyoung wrote:
> All I know is when a customer had their database on RAID 5, a 160
> million record table (+ 3 indices) took 36 hours to reload/rebuild.
> When they switched to RAID 0+1, it only took 12.
>
> An important point that many people miss is that all databases will
> periodically require maintenance. If it can not be done w/out spilling
> over into "production time" you are asking for trouble.

Another important point that people miss is it can be cheaper to buy better hardware and RAID-5 it than lesser hardware with the near-double disks required to RAID 01 it. If the better hardware means you are not running into a maintenance performance issue, then so what? Down the line when you start running into space or performance issues, maybe the disk will be cheaper... or it will be time to upgrade anyways...

jg

--
@home.com is bogus.
Push restart button for triple point play:
http://www.signonsandiego.com/uniontrib/20051206/news_1b6peregrine.html