Limitation of Data pages per fragment
Ruja Naiyanart asked for the maximum data pages per fragment on 16K pages in IDS 11.5. Keith Simmons said the page limit stays the same but 16K pages hold more rows. Art Kagel corrected that the limit is 2^24 (16,777,216) pages per fragment for any page size: just under 32 GB for 2K, about 128 GB for 8K, and a little under 256 GB for 16K. Solved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello Guru, In IDS11.5, Data pages per fragment base on 2K page size has maximum capacity per table equal 16,775,134 but if base on 16K, how many maximum capacity per table equal ?. Thank you, Ruja.
Ruja The limit is still 16,775,134 but because the pages are 8 times the size you can get (at least) 8 times the number of records in the fragment. If your records are over 1K you could get up to 15 time the records in the fragment and almost twice the records in the same physical space. Keith On 19 April 2010 15:45, RUJA NAIYANART <ruja.n@cdg.co.th> wrote: > Hello Guru, > > In IDS11.5, Data pages per fragment base on 2K page size has maximum capacity > per table equal 16,775,134 but if base on 16K, how many maximum capacity per > table equal ?. > > Thank you, > > Ruja. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >
Almost, Ruja. Always the limit for a single <fragment> of a table or index is 2^24 (or 16,777,216) pages regardless of the page size. For 2K pages that works out to just under 32GB, for 8K pages a bit under 128GB, for 16K pages a little less than 256GB, of data. I leave the other pages sizes (4K, 6K, 10K, 12K, 14K) as an exercise. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Apr 19, 2010 at 10:45 AM, RUJA NAIYANART <ruja.n@cdg.co.th> wrote: > Hello Guru, > > In IDS11.5, Data pages per fragment base on 2K page size has maximum > capacity > per table equal 16,775,134 but if base on 16K, how many maximum capacity > per > table equal ?. > > Thank you, > > Ruja. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636ed69daff0b49048498e442
Thank you very much. Ruja.