Re: Peformance degradation

Craig, > The striping prevents us from doing much in the way > of seperating tables and means that we are sharing the > database chunk with other non-Informix data. Could the > striping be undoing our defragmentation efforts? I am always wary of mixing data and "normal stuff". I would undo the striping, but it's just my opinion... > Another thing that I noticed was that, when we are inserting > into the correctly sized tables - the performance is ok. > When we tried to unload or delete - the performance was > terrible. It sounds like your entire disk set needs a re-org, not just the DB. You seem to be punishing your disk unecessarily. :) Check out the indexes on your tables as well - too many indexes murder deletes. All IMHO, of course... -- Cheers, Billy "What happens if I press this button he NO CARRIER