This is actually just a development system so there is no load to speak of on the database. I appreciate your input on the best hardware for the job. I know even just a second hi-perf drive with cache would help a lot but for now it is what it is. It just has one drive formated into 5 partitions in a 1.2GHz atholon with 1 gig memory. It's not for production use. I'm just curious how big of an effect drive fragmentation would have on this system as it is. My coworker thinks it has a huge effect on lookup performance. My guess is little to none. Unless I can come up with something to back that up I'm going to have to waste my time doing a job that I don't think needs to be done. I guess I could just do it and say I told you so but I don't really want to. Perhaps I'm wrong but I doubt it. I've been wrong before, it was this one time when I thought I was wrong but I was actually right so maybe that doesn't count ;-) - Tom On Thu, 2003-09-25 at 18:45, Sam MacDonald wrote: > Hmmm, I said OS and applications on the raid 5 set. > > Database goes on the mirror. > > Lets not mix our Raids, and lets read what I wrote. > > Sam. > > Florin Iucha wrote: > > >On Thu, Sep 25, 2003 at 04:15:01PM -0500, Sam MacDonald wrote: > > > > > >>With databases I like a configuration where the OS and applications are > >>on a Raid 5 set. I like databases on mirror sets with their own > >>controller. Again, not knowing you hardware makes it tough. > >> > >> > > > >"Let's RAID5" is the wrong thing to do with a real database. > > > >A real database has separate tablespaces so you can place data, redo > >logs, indices, sort areas, temp areas onto separate spindles. Data and > >redo logs are critical, and should be mirrored. The others are > >disposable, but you want them on the fastest spindles you have. > > > >Cheers, > >florin > > > > > > > > > _______________________________________________ > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > http://www.mn-linux.org tclug-list at mn-linux.org > https://mailman.real-time.com/mailman/listinfo/tclug-list -- Tom Penney <blots at visi.com> _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota http://www.mn-linux.org tclug-list at mn-linux.org https://mailman.real-time.com/mailman/listinfo/tclug-list