Thanks for sharing, Alex. It's worth noting, however - and perhaps more for other readers here, given fSphinx is a Python solution, and Thinking Sphinx is aimed at Rubyists that don't want to write their Sphinx configuration by hand - that Thinking Sphinx only CRC's string values. This is because Sphinx 1.10 doesn't support grouping on string facets, and previous Sphinx versions didn't support string facets at all.
Indeed, from what I can tell of your solution, you're using integers that are keys to dictionary-style tables - which hopefully most Rails developers would have set up too. With a bit of luck, they'll be using those foreign keys for their facets, instead of the strings. Granted, the TS documentation doesn't spell that out nearly as well as it could. Any non-string facets aren't CRC'd by Thinking Sphinx, as Sphinx understands them natively. So, in a lot of cases, collisions are avoided. Now that there's the release of Sphinx 2.0.1-beta, it looks like we can get some better string facet support happening, as has already been discussed on this list between Clemens Kofler and myself. With a bit of luck, Clemens and I will have some time while we're in the same city to pair program and allow TS to degrade gracefully to the existing solution for those not using Sphinx 2.0.1. Cheers -- Pat On 17/05/2011, at 6:18 PM, Alex K wrote: > Hi everyone, > > Thinking Sphinx is really cool. However its faceted search handling > seems pretty limited. Each facet value is converted to a CRC32 > integer. This will create a lot of collisions once passed millions of > facet values. > > If you are looking for more a flexible and scalable way of performing > faceted search, have a look at fSphinx: > > https://github.com/alexksikes/fSphinx > > Cheers, > > Alex > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
