From: "Geo" 

Makes a huge difference on AIX's JFS file system, don't know about SQL
server on NTFS as I've never let it get real un-optimized, I usually
schedule db maintenance to run each night or every other night. On AIX
though it's a lot of work to optimize so I let it go for well over a year
most of the time.

Geo.

"Frank Haber"  wrote in message
news:4551f8eb$1{at}w3.nls.net...
> 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.)
>

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