Path: utzoo!attcan!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!zaphod.mps.ohio-state.edu!mips!prls!pyramid!infmx!aland
From: aland@infmx.UUCP (Colonel Panic)
Newsgroups: comp.databases
Subject: Re: Number of UNIX files under INFORMIX
Keywords: UNIX XENIX INFORMIX 386
Message-ID: <5155@infmx.UUCP>
Date: 8 Sep 90 01:48:57 GMT
References: <7437@netxcom.DHL.COM>
Reply-To: aland@infmx.UUCP (alan denney)
Organization: INFORMIX Professional Services ("Peace thru Normalization")
Lines: 23

In article <7437@netxcom.DHL.COM> walid@netxcom.DHL.COM (Walid Elgamel) writes:
>	We are working in an application that use INFORMIX standard engine
>	under XENIX-386.
>	Does anyone know...when I open a database/table, how many Unix
>	file opens does that take up, per process? 
>Walid Elgamal

For SE on XENIX, it's two files per table (.dat + .idx).  Also note
that the "systables" catalog table is open at all times that the 
database itself is open.

Note that if you are using tranasaction logging, all table files used
in the transaction are kept open until the transaction is committed
or rolled back.  Therefore, the limit of tables used in a transaction
is (kernel open-files-per-process limit - 5) / 2 .

Hope this helps.

--
Alan Denney      aland@informix.com      {pyramid|uunet}!infmx!aland

 "Maturity comes from banging your head on sharp corners."
                           - B. Kliban, 1935-1990