[ic] Details of limiting matches
DB
DB at M-and-D.com
Sat Feb 17 16:45:44 EST 2007
>> IC 5.4.2/mysql. I have more than 500,000 entries in my products table,
>> but even so, the form below returns results very quickly as long as the
>> number of matches is rather low.
>>
>> <FORM>
>> <INPUT TYPE=hidden NAME=mv_searchtype VALUE=text>
>> <INPUT TYPE=hidden NAME=mv_matchlimit VALUE=100>
>> <INPUT TYPE=hidden NAME=mv_max_matches VALUE=1000>
>
>> Can anyone suggest a way to keep searches which will result in a large
>> number of matches from taking so long, for example by aborting the
>> search once a certain number of matches is exceeded, or by preventing it
>> from running in the first place so I can display a "please refine" message?
>
> Have you tried db for your searchtype?
I did, but it doesn't seem to make things any faster or slower.
DB
More information about the interchange-users
mailing list