Article View: comp.os.msdos.programmer
Article #175Re: dBase IV multiple index files?
From: Denis Beauregard
Date: Sat, 01 Aug 1992 19:52
Date: Sat, 01 Aug 1992 19:52
35 lines
2208 bytes
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!beauregaReferences:
<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