Re: Maximum table size ?

Art S. Kagel wrote: > > Helmut Leininger wrote: > > > > Hi, > > > > Is there a limit on the table size and/or number of rows in a table in > > Informix Online 7.xx? > > Maybe this information is somewhere in the manuals but I did not find > > it. > > It is in the release notes in: > $INFORMIXDIR/release/en_us/0333/SERVERS_7.? > > A tablespace is limited to 16million pages or 2^32 rows, a table may be > made up of up to 1000 tablespaces as fragments. Actually while the > engine is limited to 1000 tablespaces it is also limited to 1000 disk > chunks (which can be 4K or 2K depending on the system) so the practical > limit is <4TB (1000 * 2^32 or 1000 * 2^31). > > Art S. Kagel Art: are you sure that the number of chunks is limited to 1000? I know that this the Onmonitor limit, but I always thought that there was a much higher logical limit (practical limit being much closer to the 1000 Onmonitor limit). Mark -- +-----------------------------------------------+ | Mark Christmas mailto:mchristmas@crosskeys.com | CrossKeys Systems Corp http://www.crosskeys.com | 350 Terry Fox Dr | Kanata, ON, Canada K2K 2W5 | Phone (613) 591-1600 Fax (613) 599-2330 +-----------------------------------------------+