Page size limits

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFEB56.886AD200 Content-Type: text/plain; charset="iso-8859-1" I know that in Informix 7.24 that the upper page limit per dbspace is roughly 16.5 million, but does the same limit hold true to version 7.31? ------_=_NextPart_001_01BFEB56.886AD200 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2651.75"> <TITLE>Page size limits</TITLE> </HEAD> <BODY> <P><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"Courier New">I know that in = Informix 7.24 that the upper page limit per dbspace is roughly 16.5 = million, but does the same limit hold true to version 7.31?</FONT></P> <BR> </BODY> </HTML> ------_=_NextPart_001_01BFEB56.886AD200--

First, PLEASE do not post HTML or MIME. This is a text only newsgroup. "Farmer, Byrd G - CFC" wrote: > > I know that in Informix 7.24 that the upper page limit per dbspace is > roughly 16.5 million, but does the same limit hold true to version 7.31? The limit for all Informix servers is 2^24 PAGES or 16,777,216 pages per TABLESPACE which is a single non-fragmented table or a single fragment of a fragmented table. A dbspace is limited to 1024 chunks which is also the limit of chunks for the entire server which amount to 2TB of data per server instance, database, or even a single fragmented table. For IDS/XPS (Extended parallel server) you can have larger databases and tables by distributing the data across multiple co-servers on clustered or networked servers. Art S. Kagel