Re: fragmentation factor

Unless, of course, you are running 7.31 and reach the max number of pages in a table (16777215) :) Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: david@smooth1.co.uk >Reply-To: david@smooth1.co.uk >To: informix-list@iiug.org >Subject: Re: fragmentation factor >Date: 11 Oct 2005 12:55:10 -0700 > >Well it is hard to say ...depends upon disk seek times that are >impossible to measure with sans's etc. > >I'd say it is safer to reduce fragmentation. The problem with >fragementation is that it shows people >have not properly sized their database. I've found that fragmentation >and running out of space >tend to go together. I'm not sure any tools replaces analysing each >table and sizing it properly. sending to informix-list

"Colin Dawson" <cjd_1955@hotmail.com> wrote in message news:1129130055.7771deea52eeb37ea26e65f577dd240e@teranews... > > Unless, of course, you are running 7.31 and reach the max number of pages > in > a table (16777215) :) It's actually tablespace rather than table (can't remmeber if this is relevant because I'm not sure which post you're replying to - viewing through the newsgroup I seem to lose about half of all posts these days). But it still pertains in 9.40 certainly and, I believe, 10.0