RE: Extents Sizes
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C32A06.9FBC3D30 Content-Type: text/plain; charset="iso-8859-1" Hi, are scripts witch propose extent size bases in number of rows, indexes, row lenght, etc. The Next Extent Size depends of the expected grow of the data in the table, normaly, I use 10% of extent size as next size, but I have tables with few grow along the time. I hope these help you. The script I have is named "lst_extent.sh", surely these script is in the IIUG library. Gustavo Tobares Administrador de Sistemas y DBA Centro de Computos - Red Megatone TE: 0342-4500972 - Fax: 0342-4500940 -----Mensaje original----- De: Johnny Koen [mailto:JohnnyK@mxgroup.co.za] Enviado el: Martes, 03 de Junio de 2003 09:55 a.m. Para: informix-list@iiug.org Asunto: Extents Sizes Hi Is there a rule for creating extent size and next extent size. Kind Regards Johnny ------_=_NextPart_001_01C32A06.9FBC3D30 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40"; xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word"><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content=Word.Document name=ProgId> <META content="MSHTML 6.00.2800.1170" name=GENERATOR> <META content="Microsoft Word 10" name=Originator><LINK href="cid:filelist.xml@01C329E0.0DC010D0" rel=File-List><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> <STYLE> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} span.EmailStyle17 {mso-style-type:personal-compose; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:windowtext;} span.GramE {mso-style-name:""; mso-gram-e:yes;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </STYLE> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--></HEAD> <BODY lang=EN-US style="tab-interval: .5in" vLink=purple link=blue> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=425152719-03062003>Hi, are scripts witch propose extent size bases in number of rows, indexes, row lenght, etc. The Next Extent Size depends of the expected grow of the data in the table, normaly, I use 10% of extent size as next size, but I have tables with few grow along the time.</SPAN></FONT></DIV> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=425152719-03062003></SPAN></FONT> </DIV> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=425152719-03062003>I hope these help you.</SPAN></FONT></DIV> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=425152719-03062003></SPAN></FONT> </DIV> <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=425152719-03062003>The script I have is named "lst_extent.sh", surely these script is in the IIUG library.</SPAN></FONT></DIV> <DIV> </DIV><FONT face=Arial size=2> <P><FONT face=Arial size=2>Gustavo Tobares<BR>Administrador de Sistemas y DBA<BR>Centro de Computos - Red Megatone<BR>TE: 0342-4500972 - Fax: 0342-4500940<BR><BR></FONT></P></FONT> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Mensaje original-----<BR><B>De:</B> Johnny Koen [mailto:JohnnyK@mxgroup.co.za]<BR><B>Enviado el:</B> Martes, 03 de Junio de 2003 09:55 a.m.<BR><B>Para:</B> informix-list@iiug.org<BR><B>Asunto:</B> Extents Sizes<BR><BR></FONT></DIV> <DIV class=Section1> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Is there a rule for creating extent size and next extent <SPAN class=GramE>size.</SPAN><o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Kind Regards<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Johnny<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML> ------_=_NextPart_001_01C32A06.9FBC3D30--
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