Jonathan Espejo wrote:
> In reference with Informix Tech Notes 1998, Volume 8, Issue 3 (Tuning
> Informix Dynamic Server by Art S.Kagel) regarding tables with more than 16
> MM pages in size. As what Art said on his article that there is a limitation
> of 16 Million pages per table space. What are the issues that users might
> encounter of having tables with more than 16MM pages in size that are not
> fragmented.
The issues you *should* encounter are that you simply will not be able to add
any more rows to your table when it hits 16,777,215 pages. I've never tested
this, and I don't have the disk space to test it, so I can't tell you for sure
that it *will* fail this way, but if it doesn't, it's bound to corrupt
something. It simply cannot reference any more pages than that unless you
fragment it.
June
--
june_t@hotmail.com
Grounded in Palo Alto, living on those tube-shaped cookies, whatever they're
called...