I’ve spent some more time working on the new search functionality:
- Keywords in results are now highlighted as bold text
- Matching fragments of reviews and comments are shown, rather than just the review summary text
- Less results per page are shown, as each result tends to be larger due to the above changes
- I’ve decreased the maximum limit of results from 200 to 100. This is to counteract the increased work load generated by matching the keywords and fragments
Much as I’m very impressed with MySQL Fulltext Searching, it doesn’t offer the facility (at least in Version 4) to extract the matching text from results sets. I’ve had to do it myself in PHP using regular expressions. Not a big deal, but it did feel a little like I was having to reinvent the wheel.