Re: 16.7 million page limit in Informix

dcruncher4@aim.com wrote: > Does Informix still have 16.7 million page limit for a table in a dbspace? > No. A single partition (table fragment) is still limited to 16.7million pages. However, with page sizes extending to 32K in IDS 10.00+ that doesn't mean the partition is limited to 32GB any longer. AFAIK there are no plans to change that, and frankly, I'm not certain I want a TB+ table in a single partition with no parallel query or fragment elimination available. Art S. Kagel Oninit > DB2 since ver 9.0 has overcome that limitation. I know we can fragment > the table and that too to the same dbspace multiple times, but it would be > great if a single table can contain more than 16.7 million pages. Of course > that would mean ROWID has to be bigger than an INT. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > >