Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!swrinde!mips!prls!pyramid!infmx!aland
From: aland@infmx.UUCP (Colonel Panic)
Newsgroups: comp.databases
Subject: Re: Number of UNIX files under INFORMIX
Summary: two, in your case
Keywords: UNIX XENIX INFORMIX 386
Message-ID: <5085@infmx.UUCP>
Date: 30 Aug 90 04:20:55 GMT
References: <7437@netxcom.DHL.COM>
Reply-To: aland@infmx.UUCP (alan denney)
Organization: INFORMIX Professional Services ("Peace thru Normalization")
Lines: 24

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

Each table consists of two files (three on Create Locking ports; I
think all of the XENIX and UNIX 386 ports use sys5 locking):
the data file (.dat suffix) and the index file (.idx suffix).

When you have a database open, its systables catalog table is kept
open at all times.  Otherwise, it depends on what tables are in use.

The Turbo and OnLine engines just need one file for each physical
chunk, regardless of the number of tables used.

Hope this helps.

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

 "Girl, we couldn't get much higher."  -  Joe Isuzu