Sphinx or MySQL Full-text for searching through sub-1000 data entries?

0
votes

Should I use Sphinx or MySQL full-text for searching through no more than 1000 database entires in different tables?

Later on I plan to display the entries that match the search keywords on a map as points.

1
mysqlfull-text-searchsphinx

1 Answers

2
votes

All depends on your level of use and need. I would suggest you start with MySQL full-text searching - its easier to implement and will get you to production faster. You can always plan to upgrade later as your demands dictate.