[ic] Details of limiting matches

Peter peter at pajamian.dhs.org
Sat Feb 17 16:20:04 EST 2007


On 02/17/2007 12:18 PM, DB wrote:
> 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?

Peter


More information about the interchange-users mailing list