CODEWITHSUNDEEP
autocompletesphinx
nnikolay
nnikolay

Reputation: 1751

autocomplete search with sphinx

I am looking for a very fast autocomplete solution for displaying results in mobile apps. I am using sphinx as full text index solution, but I thing if sphinx is the best one solution for autocomplete search, because after the index is searched, then I need to ask mysql for the results. Is there better and faster solution?

Upvotes: 0

Views: 3444

Answers (3)

barryhunter
barryhunter

Reputation: 21091

Well you can use string attributes, to store the actual text.

Then you don't need to go back to the database at all. Can just query sphinx. Sphinx stores attributes in memory; so doesn't slow the actual sphinx query searching down noticeably.

Sphinx works well for autocomplete in my experience.

Upvotes: 1

Imraan
Imraan

Reputation: 687

Sphinx supports wildcard searching. Have a look at the parameter "enable_star". If you set it to 1 and restart sphinx, you should be able to search using wildcards.

Check it out in the Sphinx docs.

To find matches where any word contains "micro", the search term needs to be "micro".

Upvotes: 1

aric
aric

Reputation: 17

If you are running sphinx 2.0.2 or greater:

index_exact_words = 1

Upvotes: 1

Related Questions