Re: Max number of tables

Posted in 1993

Graeme Sargent — Thu, 5 Aug 1993 11:24:56 GMT — source: Informix-list mailing list archive (1991-1998)

In <115030002@hpsgm2.sgp.hp.com> chanm@hpsgm2.sgp.hp.com (Michael CHAN) writes: > Hello, > We currently are thinking of a design where there will be 2400 database > tables. We like to know whether Informix has any upper limit on the > number of tables, 16,777,216 > the size of each table, 4,278,190,080 rows or 16,777,216 pages (excluding Blobspace BLOBS). > and whether there will be > any adverse impact on the search performance if there are so many tables. No. (at least there shouldn't be, can't say that I've tested it!) graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.