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. On Tue, May 26, 2015 at 11:44 AM, Pat Allan <[email protected]> wrote: > 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 > > On 24 May 2015, at 4:40 am, J. Garcia <[email protected]> wrote: > > 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. > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. > > > -- > 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 > [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
