I'm using MySQL/PHP to create a system to search about 9 million records, spread over a couple tables (the biggest has 5 million records). The script counts the total number of results, then displays the first ten. Most of the time it works great, but when the search is too vague and a lot of...