RE: number of extents

Careful with that first size. Index space allocation is made according to fextsize. Better to select a smaller fextsize followed by a large nextsize. load the table, and then alter the nextsize downward. If you load the tables one by one, there is a good chance that the second extent will be 'appended' to the first extent instead of being created as a separate extent. cheers j. Philip sagely spake these words of wisdom: > -----Original Message----- > From: Phillip [mailto:tienp@wholefoods.com] > Sent: Tuesday, January 30, 2001 6:36 PM > To: informix-list@iiug.org > Subject: Re: number of extents > > > Denmark, > > Remember to > first find out what > to set initial extent and next extent to, run onstat -pt to > get your table stats > such as #pages allocated. The modify the dbimport script to > reflect initial > (based on # pages allocated) and next extent size (about 10% > of initial) so as > to grab all that contiguous space from the get go. Remember > that when you set > extent sizes, the units are in KB while the onstat reports > are in units of > pages. > > [deletia]

Parker, Jack <JParker@engage.com> wrote in message news:959mk7$c25$1@news.xmission.com... > > > Careful with that first size. Index space allocation is made according to > fextsize. Not in IDS 9.2x, although I take the point that the original question was about 7.31. > Philip sagely spake these words of wisdom Is this a tautology? Maybe not.

Neil Truby wrote in message <95a3bj$m8q$1@taliesin2.netcom.net.uk>... > >Parker, Jack <JParker@engage.com> wrote in message >news:959mk7$c25$1@news.xmission.com... >> >> >> Careful with that first size. Index space allocation is made according to >> fextsize. > >Not in IDS 9.2x, although I take the point that the original question was >about 7.31. > Clarifications please? Are you saying that 7.31 does it, but 9.21 doesn't (and here's the crunch for the future) 9.XX will never do it, future 7's won't do it? Or can we expect this behaviour to arrive in 9.31 or equiv as the sources are shared and it will stay with us into the future until something new is invented?