simple searches on large data sets

[Robert Fournerat <robert@netin.com>]

Hi,

I have a products.asc with about 250,000 items (but only 
4 columns).  The way I have things configured right now,
it takes mv (3.14) about 16 seconds to return an item from
a search (ie: search for a part number in the code column).
When I grep for the part number, grep returns in less than
a second.

How can I optimize this search, to return the page more
quickly?

I am using the search facility in "leftside", and have
added:

[set hardpart_profile]
  mv_search_field=0
  mv_orsearch=no
  mv_substring_match=no
  mv_coordinate=yes
  mv_exact_match
[/set]

in leftside as well.  I have defined

Database            products     products.asc      TAB
Database            products     INDEX             code

in the catalog.cfg file.

Is there anything else I can do?

thanks,
Robert