Effecient Text Search

[Will Meyers]

Hi all,

Just a quick question. I'm working on a general search function for my application and just wanted your opinions before I do any sort of benchmarking.

Right now I have a PostgreSQL database with a table (model) which includes a title column and summary column (both charfields).

Would it be more efficient to call:

v = SearchVector(title, weight='A') + SearchVector(summary, weight='A')

results = MyModel.objects.annotate(rank=SearchRank(v, 'my query')).filter(rank__gte=0.5)

Or should I join the title and summary (i.e. create a new column title_summary within the model which just concats them) and do the search on that with:

v = SearchVector(title_summary, weight='A')

results = MyModel.objects.annotate(rank=SearchRank(v, 'my query')).filter(rank__gte=0.5)

Thanks!

[Suraj Thapa FC]

You should look for elasticsearch 

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7c884279-de2e-42ad-a18b-2f2e49315954%40googlegroups.com.