Limitation of Data pages per fragment

Posted in 2010

RUJA NAIYANART — Mon, 19 Apr 2010 14:45:54 — source: IIUG Forums & Mailing Lists

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.

↪ replying to RUJA NAIYANART

Keith Simmons — Mon, 19 Apr 2010 14:57:55 — source: IIUG Forums & Mailing Lists

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. > >

↪ replying to RUJA NAIYANART

Art Kagel — Mon, 19 Apr 2010 15:48:47 — source: IIUG Forums & Mailing Lists

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

↪ replying to Keith Simmons

RUJA NAIYANART — Tue, 20 Apr 2010 05:51:51 — source: IIUG Forums & Mailing Lists

Thank you very much. Ruja.