From: "Robert Comer" 

It makes a huge difference on SQL Server too, I have to optimize pretty frequently.

The AS/400 doesn't need it though. 

--
Bob Comer


"Geo"  wrote in message
news:4556a115$2{at}w3.nls.net...
> 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