Re: simple searches on large data sets

["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.

--
Bill Betz
bill@pennherb.com
Penn Herb Company, Ltd.
10601 Decatur Road
Philadelphia, PA 19154
(215) 632-6100 X301
--
Visit our websites at:
http://www.pennherb.com and http://www.olbas.com
--
Over 7000 herbs and healthy products on line at:
http://www.pennherb.com/cgibin/herbstore.cgi
--