17 Jan
2001
17 Jan
'01
5:31 p.m.
John Eikenberry wrote:
Can you tell us a bit about how many indexes (and what types) you were maintaining about each object? Another poster reported no problems with 60,000 objects.
I was testing and had a real simple setup. In addition to the default indexes I had 1 index on a string type (of 10 chars or less - last names), 2000 objects indexed. The vocabulary only had the entries for this field in it.
Everything was nice and fast except partial searching. It was fast enough when ther were small numbers of matches. But as the number of matches grew the time it took grew along with it, at a nearly expontial rate.
By 'partial searching' do you mean wildcard searching with the '?' and '*' wildcards? Thanks, Michael Bernstein.