🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.os.msdos.programmer
Article #175

Re: dBase IV multiple index files?

#175
From: Denis Beauregard
Date: Sat, 01 Aug 1992 19:52
35 lines
2208 bytes
In article <92213.163449APPMS@CUNYVM.BITNET> APPMS@CUNYVM.BITNET (Alexandre Pechtchanski) writes:
>=========================================================================
>Hi, everybody:
>I've heard a statement that seems pretty doubtful to me:
>"... With .MDX files, all indexes are updated automatically, with
>only one DOS File Handle, instead of one DOS File Handle for each index.
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>This frees up RAM and ... to make program more efficient (read faster)."
>^^^^^^^^^^^^^^^^^                              ^^^^^^^^^^^^^^^^^^^^^^

I checked this in dBASE manual.  ONE .MDX file can contain up to 47
indexes corresponding each to one .NDX file.

>I was always pretty sure that no matter what you do you have to allocate
>one DOS file handle (either explicitly or implicitly) for each file you
>access.  For dBase it spells one handle for each .DBF + one for each
This is true.

>.NDX etc.  The only way (IMHO) to circumvent it is to use one handle
This is also true.

>for different files at different time, but it sure will lead to
This is false.  You could put many indexes in one file.

>Alex Pechtchanski, GCRC System Manager   voice: (212) 241-1804
>Mount Sinai Medical Center, New York  |-------------------------
>INTERNET: DESNICK@MSVAX.MSSM.EDU      |#include <std.disclaimer>
>BITNET:   APPMS@CUNYVM                |


-- 
  \_\    Denis Beauregard  *  internet:beaurega@ireq.hydro.qc.ca
 /   \   Genealogiste officiel : Beauregard/Jarret/Jarest/Vincent
J   __>  Barthelemy Jarret (1471) -> Andre Jarret, sieur de Beauregard (1665)
\_.-===   -> Denis Beauregard (1992)                  Opinions ? Et pis non !
Technical Details
Message-ID: <BsBLuu.By1@ireq.hydro.qc.ca>
Path: arc1-ca.pugleaf.net!sparky!uunet!bonnie.concordia.ca!hobbit.ireq.hydro.qc.ca!beaurega
References: <92213.163449APPMS@CUNYVM.BITNET>

Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!sparky!uunet!bonnie.concordia.ca!hobbit.ireq.hydro.qc.ca!beaurega
From: beaurega@ireq.hydro.qc.ca (Denis Beauregard)
Newsgroups: comp.os.msdos.programmer,bit.listserv.dbase-l
Subject: Re: dBase IV multiple index files?
Message-ID: <BsBLuu.By1@ireq.hydro.qc.ca>
Date: 1 Aug 92 19:52:05 GMT
References: <92213.163449APPMS@CUNYVM.BITNET>
Sender: news@ireq.hydro.qc.ca (Netnews Admin)
Organization: Institut de recherche d'Hydro-Quebec, Varennes, Canada
Lines: 35