CODEWITHSUNDEEP
ruby-on-railspostgresqlherokusphinxthinking-sphinx
Mayowa
Mayowa

Reputation: 143

RoR: Optimal Search Package for 16k+ Record Database

I have a database in (psql) that contains about 16,000 records; they are the titles of movies. I am trying to figure out what is the most optimal way to go about searching them (currently they are being searched via the web on a Heroku hosted website for Ruby on Rails). However, some queries such as searching for something like the word 'a' can take up to 20 seconds. I was thinking of using Sphinx however, such packages are advertised for full text searching, so I am wondering if that is appropriate for my problem. Any advice would be appreciated.

Upvotes: 0

Views: 92

Answers (2)

Gul
Gul

Reputation: 1767

If your database is on PSQL then sphinx is not possible as up till now heroku postgres is not supported to work with sphinx so the remaining choice so far is to use solr which is also good for full text search and some simple steps to make it implement.

Upvotes: 0

Yavar
Yavar

Reputation: 11933

16000 records are too few both in both number and size (as you said title) to qualify for a Search Engine search. Try out normal full text search of your database. Set up the indexes for making it faster.

However this does not stop you from trying out some Search Engine like Sphinx or Solr. Both are open source. Sphinx pretty easy to setup too. But again to reiterate there is no need for this as the data size is too less and comes under the domain of Database Full Text Search.

Upvotes: 1

Related Questions