I know someones gonna ask why

so here go's

we offer over a million products and even though our server is a beast the database is very sluggish on searches.

i would like one searchbox that will search nothing but model # (which has been turned into isbn)

and one that searches nothing but product name and stops after the first 200 rows that match the search criteria.

we do not want to search description at all as our descriptions come from amazon feeds.

i know im asking alot but if anyone can help it would really be appreciated.

to view an example of our cart http://aepbooks.com/shop1/

thanks
Mike z