Re: informix limitations (globally) against to ORACLE, SQL SErv and so on.

Posted in 1998

Art S. Kagel — Thu, 05 Nov 1998 16:11:48 -0500 — source: Informix-list mailing list archive (1991-1998)

Dariusz Tomon wrote: > > As in the topic Which Informix? Online 7.xx? Or 8.xx the limits differ. Vers 7.xx then: Max size of a table fragment: 16 * 2^20 pagees (~32GB on 2Kpage system) Max number of fragments per table: 1024 (on 2K page systems) Max number of server chunks: 1024 (currently 2GB each for 2TB total) 64 bit implementations may expand this Max number of dbspace: 1024 (on 2K page systems) Max rowsize (w/out BLOB columns): 32K Max number of indexed columns: 32 Max number of tables per database: unlimited Max number of databases per instance: unlimited The conpetition I do not know. Art S. Kagel