From: Ad 

Frank Haber wrote:
> Hey, here's my chance.  I know you guys are SQL/XML developers, and only
> rarely use a production database under load.  On tho rare occasions you
> do, have you developed any impression on how much difference a
> compaction/reindex makes on EXT3?  On NTFS?  My ignorant impression is
> "very  little," but I haven't played with a transaction/data-entry
> system under load (they won't let me, and they took away my crayons, too).
>
> (I know on big stuff you'd have to discount front end diffs, net load,
> muddleware - in other words, half the system, but I'm looking for
> general impressions.  Rumors from your sysadmins will be gratefully
> accepted, too.)

Really....it all depends on the RAM. Unless you have stonking great tables,
nowadays when RAM is cheap......& 2-4GB is not out of the
question......

The vast bulk of most operational data (i.e. that which is frequently
accessed) can be held in RAM & then the disk writes are just to persist
the data.

Adam

--- BBBS/NT v4.01 Flag-5