Re: Next Extent Calc.

Paul Mosser wrote: > > 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. Okay, that's useful, but it still relies on the "... user-specified growth factor..." as you say. That is the calculation not even the client can normally give you. :-) > We were using this on OnLine v5.xx. Is the routine still around > somewhere? Has it been updated for v7.xx? I haven't seen it. It should still apply to version 7.x. The BaaN Fast Start package comes with a script (if you buy the package) which does this job AFTER the event, i.e. de-frags your 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"!|/ ////////| +----------------------+-----------------------------------+-----------+