duplicated results on model search

[J. Garcia]

I have a model with ActiveRecord indexing and deltas.

When searching on this model, sometimes I get duplicated results.
I have verified that these duplicates do have delta set to true.

Does Thinking Sphinx handle the elimination of duplicates in the results?

Using TS 3.1.3, Sphinx 2.2.7.

J.

[Pat Allan]

Hi J

I’ve not seen this issue before… can you share the index definition for the model where this happens? Though I’m presuming it’s pretty standard…

— 

Pat

--
You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thinking-sphi...@googlegroups.com.
To post to this group, send email to thinkin...@googlegroups.com.
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.

[J. Garcia]

Hi Pat,

Thanks for your response.

I need to further investigate this. Will come back to it soon after I take care of other indexing issues.

I'll add TS/SphinxSearch was a live saver for me: I had a slow query on a database with about 150M records in total across 7 related tables (56 secs with cold cache and cold DB) and reduced it to 0.3 secs with a proper TS index and query!

I had done every possible MySql query and index optimization before that but 56 s was the most performant result before digging into table partitioning which was going to be complicated and did not guarantee any significant improvement.

--
You received this message because you are subscribed to a topic in the Google Groups "Thinking Sphinx" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/thinking-sphinx/D7qnIbjmWdE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to thinking-sphi...@googlegroups.com.