Path: utzoo!censor!geac!torsqnt!news-server.csri.toronto.edu!cs.utexas.edu!yale!cmcl2!panix!alexis
From: alexis@panix.uucp (Alexis Rosen)
Newsgroups: comp.databases
Subject: Re: More memory efficient index files in Foxpro - help!
Keywords: index,foxpro,xbase
Message-ID: <1990Dec3.004101.18380@panix.uucp>
Date: 3 Dec 90 00:41:01 GMT
References: <9732@fy.sei.cmu.edu>
Organization: PANIX - Public Access Unix Systems of NY
Lines: 24

There are several approaches to your problem:
1) Presumably, you aren't printing the entire database on each report. So
you shoudl do the "right" thing, and not use indices at all. According to
Fox, sorting to a file and then printing the file is faster. It will also
use much less space, unless you're printing a large fraction of the total
number of records.

2) Use the For clause in the index command. This will only create entries
in the index for records which you specify.

3) Wait for FoxPro 2.0 (about 4-6 months, I think). That damn thing is so
fast that the new preferred way of dealing with this problem is to create
an index on everything and then use filters! The new indices are smaller,
as well (by about a factor of 3-6).

4) Keep databases of the records you're interested in for each report you
print. Add to them as well as the main file. Rebuild occasionally.

Methods #1 and #2 are probably best for now.

---
Alexis Rosen
Owner/Sysadmin, PANIX Public Access Unix, NY
{cmcl2,apple}!panix!alexis


Brought to you by Super Global Mega Corp .com