Re: Extent sizing question.

Here is a 4GL I wrote to help me estimate my first and next extent sizes. We had no variable length fields or datetime fields when I wrote this so it bodges those calculations a bit but it does give a rough guide. Fergus Ed Bidinotto wrote in message <352A5064.5CDD@po1.cobe.com>... >Here's a better picture of what I am trying to calculate on my tables > >I've run an oncheck against a table to see what data pages are begin >used and then divide that by the number of months since creation to get >a monthly growth rate. Then I multiply that by 12 to get a year. This >will give me a years growth. > >How can I fine tune the 1st extent so I am not wasting space? begin 666 Calc_ext.4gl M>RTM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM?0T*>R!0<F]G<F%M M(#H@8V%L8U]E>'0N-&=L(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @(" @(" @(" @?0T*>R!!=71H;W(@(#H@1F5R9W5S M($AA>6YE(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @?0T*>R!$871E(" @(#H@,2!$96-E;6)E<B Q.3DU M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @?0T*>R @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @?0T* M>R!$97-C<FEP=&EO;B @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @?0T*>R M+2TM+2TM M+2TM+2 @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @ M(" @(" @(" @(" @(" @(" @(" @(" @?0T*>R!0<F]G<F%M('1O(&1E=&5R M;6EN92!T:&4@:6YI=&EA;"!E>'1E;G0@<VEZ97,@;V8@9FEL97,N(" @(" @ M(" @(" @(" @(" @(" @?0T*>RTM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM?0T*#0I$051!0D%312!P96YT0&QI=F4R#0H-"D=,3T)!3%,-"@T* M1$5&24Y%#0H@(&=?=&]T7W-I>F4@24Y414=%4BP-"B @9U]E>'1?<VEZ92!) M3E1%1T52+ T*("!G7W)O=U]S:7IE($E.5$5'15(L#0H@(&=?:61X7W-I>F4@ M24Y414=%4BP-"B @9U]N;U]R;W=S("!)3E1%1T52+ T*("!G7VYO7V9U=%]R M96-S("!)3E1%1T52+ T*("!G7W1A8E]N86UE($Q)2T4@<WES=&%B;&5S+G1A M8FYA;64L#0H@(&=?<WES=&%B(%)%0T]21"!,24M%('-Y<W1A8FQE<RXJ+ T* M("!G7W-Y<V-O;"!214-/4D0@3$E+12!S>7-C;VQU;6YS+BHL#0H@(&=?<WES M:61X(%)%0T]21"!,24M%('-Y<VEN9&5X97,N*@T*#0I%3D0@1TQ/0D%,4PT* M#0H-"DU!24X-"@T*("!)1B!G971?<&%R86US*"D@5$A%3@T*#0H@(" @3$54 M(&=?;F]?<F]W<R @/2 P#0H@(" @3$54(&=?=&]T7W-I>F4@/2 P#0H-"B @ M("!#04Q,(&-A;&-?<F]W7W-I>F4H*0T*(" @($-!3$P@8V%L8U]I9'A?<VEZ M92@I#0H@(" @0T%,3"!C86QC7VYO7W)O=W,H*0T*(" @($-!3$P@8V%L8U]T M;W1A;',H*0T*(" @($-!3$P@<')I;G1?<F5S=6QT<R@I#0H-"B @14Y$($E& M#0H-"D5.1"!-04E.#0H-"@T*#0I&54Y#5$E/3B!G971?<&%R86US*"D-"@T* M1$5&24Y%#0H@(&Q?<F5S("!334%,3$E.5 T*#0H@($Q%5"!L7W)E<R ](%12 M544-"@T*("!)1B H;G5M7V%R9W,H*2 \\/B R*2!42$5.#0H@(" @1$E34$Q! M62 B26YC;W)R96-T(&%R9W5M96YT<R M('1A8FQE(&YA;64L(&YO(&9U='5R M92!R96-O<F1S(@T*(" @($Q%5"!L7W)E<R ]($9!3%-%#0H@($5,4T4-"B @ M("!,150@9U]T86)?;F%M92 ](&%R9U]V86PH,2D-"B @("!,150@9U]N;U]F M=71?<F5C<R ](&%R9U]V86PH,BD-"B @14Y$($E&#0H-"B @248@*&Q?<F5S M(#T@5%)512D@5$A%3@T*(" @(%=(14Y%5D52($524D]2($-/3E1)3E5%#0H- M"B @("!314Q%0U0@*B!)3E1/(&=?<WES=&%B+BH-"B @(" @($923TT@<WES M=&%B;&5S#0H@(" @(%=(15)%('1A8FYA;64@/2!G7W1A8E]N86UE#0H-"B @ M("!72$5.159%4B!%4E)/4B!35$]0#0H-"B @("!)1B H<W1A='5S(#T@,"D@ M5$A%3@T*(" @(" @3$54(&Q?<F5S(#T@5%)510T*(" @($5,4T4-"B @(" @ M($Q%5"!L7W)E<R ]($9!3%-%#0H@(" @("!#05-%#0H@(" @(" @(%=(14X@ M*'-T871U<R \\(# I#0H@(" @(" @(" @1$E34$Q!62 B4V5L96-T(&9A:6QE M9"P@4U%,($5R<F]R("(L('-T871U<PT*(" @(" @(" @($58250@0T%310T* M(" @(" @("!72$5.("AS=&%T=7,@/2!.3U1&3U5.1"D-"B @(" @(" @("!$ M25-03$%9(")486)L92!N;W0@9F]U;F0B#0H@(" @(" @(" @15A)5"!#05-% M#0H@(" @("!%3D0@0T%310T*(" @($5.1"!)1@T*("!%3D0@248-"@T*("!2 M15154DX@;%]R97,-"@T*14Y$($953D-424].#0H-"@T*#0I&54Y#5$E/3B!C M86QC7W)O=U]S:7IE*"D-"@T*1$5&24Y%#0H@(&Q?<F5C<R!)3E1%1T52+ T* M("!L7W)E<R @1$5#24U!3"@Q,"PR*0T*#0H@($Q%5"!L7W)E8W,@(" @(#T@ M, T*("!,150@9U]R;W=?<VEZ92 ](# -"@T*("!$14-,05)%(&-?8V]L=6UN M<R!#55)33U(@1D]2#0H@(" @4T5,14-4("H@#0H@(" @("!&4D]-('-Y<V-O M;'5M;G,-"B @(" @5TA%4D4@=&%B:60@/2!G7W-Y<W1A8BYT86)I9 T*#0H@ M($9/4D5!0T@@8U]C;VQU;6YS($E.5$\\@9U]S>7-C;VPN*@T*#0H@(" @3$54 M(&Q?<F5C<R ](&Q?<F5C<R K(#$-"@T*(" @($Q%5"!L7W)E<R ](&-A;&-? M<VEZ92AG7W-Y<V-O;"YC;VQT>7!E*0T*(" @($E&("AL7W)E<R \\(# I(%1( M14X-"B @(" @($1)4U!,05D@(E5N<W5P<&]R=&5D(&1A=&$@='EP92!I;B!T M86)L92 B+&=?=&%B7VYA;64-"B @(" @($58250@4%)/1U)!30T*(" @($5. M1"!)1@T*(" @($Q%5"!G7W)O=U]S:7IE(#T@9U]R;W=?<VEZ92 K(&Q?<F5S M("![('-I>F4@;V8@9&%T82!I;B!T86)L92!]#0H-"B @14Y$($9/4D5!0T@- M"@T*("!)1B H;%]R96-S(#T@,"D@5$A%3@T*(" @($1)4U!,05D@(DYO(')O M=W,@9F]U;F0@:6X@=&%B;&4@(BQG7W1A8E]N86UE#0H@(" @15A)5"!04D]' M4D%-#0H@($5.1"!)1@T*#0H@($Q%5"!G7W)O=U]S:7IE(#T@9U]R;W=?<VEZ M92 K(#0@("![('-L;W0@=&%B;&4@96YT<GD@?0T*(" -"D5.1"!&54Y#5$E/ M3@T*#0H-"@T*1E5.0U1)3TX@8V%L8U]I9'A?<VEZ92@I#0H-"D1%1DE.10T* M("!L7W)E8W,@24Y414=%4BP-"B @;%]R97,@($1%0TE-04PH,3 L,BD-"@T* M("!,150@;%]R96-S(" @(" ](# -"B @3$54(&=?:61X7W-I>F4@/2 P#0H- M"B @1$5#3$%212!C7VEN9&5X97,@0U524T]2($9/4@T*(" @(%-%3$5#5" J M( T*(" @(" @1E)/32!S>7-I;F1E>&5S#0H@(" @(%=(15)%('1A8FED(#T@ M9U]S>7-T86(N=&%B:60-"@T*("!&3U)%04-((&-?:6YD97AE<R!)3E1/(&=? M<WES:61X+BH-"@T*(" @($Q%5"!L7W)E8W,@/2!L7W)E8W,@*R Q#0H-"B @ M("!#04Q,(&=E=%]I;F1E>%]R;W<H9U]S>7-I9'@N<&%R=#$I#0H@(" @0T%, M3"!G971?:6YD97A?<F]W*&=?<WES:61X+G!A<G0R*0T*(" @($-!3$P@9V5T M7VEN9&5X7W)O=RAG7W-Y<VED>"YP87)T,RD-"B @("!#04Q,(&=E=%]I;F1E M>%]R;W<H9U]S>7-I9'@N<&%R=#0I#0H@(" @0T%,3"!G971?:6YD97A?<F]W M*&=?<WES:61X+G!A<G0U*0T*(" @($-!3$P@9V5T7VEN9&5X7W)O=RAG7W-Y M<VED>"YP87)T-BD-"B @("!#04Q,(&=E=%]I;F1E>%]R;W<H9U]S>7-I9'@N M<&%R=#<I#0H@(" @0T%,3"!G971?:6YD97A?<F]W*&=?<WES:61X+G!A<G0X M*0T*#0H@($5.1"!&3U)%04-(#0H-"B @3$54(&=?:61X7W-I>F4@/2!G7VED M>%]S:7IE("L@*#@@*B!L7W)E8W,I#0H-"D5.1"!&54Y#5$E/3@T*#0H-"@T* M1E5.0U1)3TX@9V5T7VEN9&5X7W)O=RAP7V-O;&YO*0T*#0I$149)3D4-"B @ M<%]C;VQN;R @($Q)2T4@<WES8V]L=6UN<RYC;VQN;RP-"B @;%]R96-S($E. M5$5'15(L#0H@(&Q?<F5S("!$14-)34%,*#$P+#(I#0