Re: Maximum extents

This is a multi-part message in MIME format. --------------4B168EB5DB5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Mickey Mestel wrote: > > > Well, there is no fixed answer because it depends on the table. But > > I've seen 200 in some documentation in the past. > > i think it is in the performance guide, i'm not sure. but no one has > rasied the issue, why do you need to know? you take a performance hit > when the number of extents is greater than 8, more than will fit on one > page. I didn't see the original question, but the limit of 8 extents per table was up to version 5.x, because only the first 8 extents are tracked in SHM. In version 6.x onwards extents are tracked in the virtual portion of SHM, and therefore the number is dynamic. > the bottom line is that you should do everything you can to make sure > that a table never has more than 8 extents. This is not so true now in 7.x, but is still a good rule of thumb to bear in mind, in order to reduce fragmentation of tables. Cheers, -- --------------4B168EB5DB5 Content-Type: text/plain; charset=us-ascii; name="ATT_SIG.TXT" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="ATT_SIG.TXT" Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+ --------------4B168EB5DB5--