[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