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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.