RE: Next Extent Calc.

Mark, I think he's asking for a way to calculate what to set NEXT SIZE to in an ALTER TABLE stmt. At my former job, we obtained from an Informix consultant a little C routine called "ext_size". Based on user-specified growth factor(s), it would spit out all sorts of good stuff, including recommended NEXT SIZE. We were using this on OnLine v5.xx. Is the routine still around somewhere? Has it been updated for v7.xx? -- -- -- -- -- -- -- -- -- -- -- Paul A. Mosser, Developer/DBA MiniSoft, Inc. Phoenix, AZ U.S.A. pmosser@minisoftinc.com } -----Original Message----- } From: Mark D. Stock [SMTP:mdstock@informix.com] } Sent: Thursday, September 04, 1997 11:42 AM } To: informix-list@rmy.emory.edu } Subject: Re: Next Extent Calc. } } Manuel wrote: } > } > Hi, } > } > I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. } > } > Does anyone know of a script or program to calculate the } > next extent size ? } } Do you mean the next extent size? That's like asking us to calculate } what your having for dinner tonight. :-) } } The next extent size for each table will depend on the anticipated } growth of that table, and how many extents you will allow per table. } } Cheers, } -- } Mark. } } +----------------------------------------------------------+---------- } -+ } |Mark D. Stock - Informix SA http://www.informix.com |//////// } /| } |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / } //| } | +-----------------------------------+//// / } ///| } | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / } ////| } | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / } /////| } |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ } ////////| } +----------------------+-----------------------------------+---------- } -+