Re: extent size ?
At 11:30 PM 02-07-98 +0800, Yew Fei wrote:
>I have a table with the following structure :
>
>create table bill_trans
>(
>bill_no integer,
>bill_date date,
>bill_time time,
>bill_item char(40),
>bill_amt dec(16,2),
>primary key(bill_no)
>)
>lock mode row ;>
>Estimation of records per day : 20,000
>
>what is the optimum extent size (first extent size) and next extent size
>shall I used to create this table ?
>
>**** Appreciate if you could list down the steps of estimating the
>extent size ****
You can find these steps in the "Informix Guide to SQL Tutorial",
on page 10-12 of the December 1991 edition. (The version that I happen
to have at hand.) You can download the latest version of this manual
in electronic form from the Informix web site at http://www.informix.com .
Also, they have been put into program form and are on the web site of
the International Informix Users Group at http://www.iiug.org .
(Follow the links through "Software", "Index", to the "Database
Administration" section.
I like to set the first extent size sufficient to hold the
entire table's data (records per day * days required to store)
and set the next extent size to a similar value even though it
won't be used for next extents--it is used for other parameter
sizing by the engine.
Be sure to read the section on extent concatenation as well.
Hope that helps,
_____________________________________________________________
Clem Akins (aka clem@informix.com) Menlo Park x5937
Customer Course Development Manager Informix Software, Inc
Last seen: "Where the heavens meet the earth", atop Mt Shasta