Re: simple searches on large data sets

[Robert Fournerat <robert@netin.com>]

Bill Betz wrote:
> 
> ******    message to minivend-users from "Bill Betz" <bill@pennherb.com>     ******
> 
> > Thanks Bill!
> >
> > Using the method that uses binary searches, I was able
> > to drop the search time to around the 1 second mark.
> >
> > But I had to build the products.asc.code file by hand
> > (well, I mean with the normal unix sort command).  Is
> > there a way to have this file built automatically?  I
> > thought the
> >
> > Database            products     INDEX             code
> >
> You probably *don't* want to use "code" in this line. "code" is already in
> the INDEX file.
> Use another field in your record, perhaps "itemnumber" or whatever field you
> want to use.
> MV will create the file for you automatically upon restart.
> 

But I want the file to be indexed on the code field.  The
code field is the _only_ field (for this catalog) that I 
need indexed.  Are you saying that there is an index built 
automatically using code as the sort field?  If so, what is 
the name of that index or file?

thanks,
Robert