>From what I understand, Sphinx's mysql41/SphinxQL protocol (which TS v3) uses >is supposed to be slightly faster than the older binary one (used by TS >v1/v2), so I guess that matches.
That said, it's almost certainly a Sphinx issue - perhaps it's worth asking on the Sphinx forum? http://sphinxsearch.com/forum/ -- Pat On 26/07/2013, at 10:58 PM, Jonathan del Strother wrote: > I'm running Sphinx 2.0.8, and I was on TS 2.0.14 but have just upgraded to > 3.0.4. The upgrade hasn't made a noticeable different to the > common-word-slowness, but I think querying in general is a little faster > (it's a bit early to tell). > > > > On Friday, 26 July 2013 10:19:08 UTC+1, Pat Allan wrote: > For reference: what versions of Sphinx and Thinking Sphinx are you using? > > On 26/07/2013, at 5:18 AM, Jonathan del Strother wrote: > > > > > I'd also be curious to see if adding these small overly common words to the > > stopwords file has an impact. > > > > > > I'll try & give it a go sometime. > > > > I've now added stopwords for a big chunk of our most common 'uninteresting' > > words ("a", "the", "I" etc). It's helped a little, but I still have quite > > a few slow queries where common words crop up that I don't want to exclude > > from searching. > > > > -- > > 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/groups/opt_out. > > > > > > > > -- > 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/groups/opt_out. > > -- 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/groups/opt_out.
