Re: Extents Sizes

Posted in 2003

Jack Parker — Wed, 4 Jun 2003 17:34:06 -0400 — source: Usenet: comp.databases.informix

Growth depends on your environment. If you plan to 'fire and forget' then several years yes. With an actively monitored/maintained database, I would plan growth on a quarter or even monthly basis (i.e. YMMV). As for sizing There are sizing utilities around - I have an excel spreadsheet I use. cheers j. ----- Original Message ----- From: "Malc P" <malc_p@btinternet.com> To: <informix-list@iiug.org> Sent: Wednesday, June 04, 2003 4:32 AM Subject: Re: Extents Sizes > 1) DON'T post MIME! > 2) When responding to a BIG message, SNIP IT!!!!!!!! > 3) extents can be fairly roughly estimated by determining the rowsize > of the table, the initial number of rows expected and the expected > growth rate. > Allow for a couple of years growth so that by that time new disk > technology has come along allowing cheaper disk. > > Malc >