Hi Gabe
It all sounds feasible, but I've only recently added a patch that handles the
long lines properly. What version of Thinking Sphinx are you using? And if you
have it installed as a gem, what version of the Riddle gem do you have as well?
--
Pat
On 22/07/2010, at 9:13 AM, Gabe da Silveira wrote:
> So I have a very complex internationalized index that has really
> pushed the boundaries of what is possible in sphinx. Crazy stuff
> like:
>
> has "GROUP_CONCAT(CONCAT(authorizations.distributor_id,
> LPAD(authorizations.country_id, 3, 0)) SEPARATOR ',')", :type
> => :multi, :as => :country_distributor_composite_id
>
> Now I am faced with needing to create a different sort order for each
> country. That means 248 separate attributes generated from the list
> of countries like this:
>
> Country.all.each do |country|
> has "IF(authorizations.country_id = country.id,
> authorizations.created_at, NULL)", :type => :datetime, :as
> => :"authorized_at_in_#{country.code}"
> end
>
> I have no idea whether this will be performant or not... I wanna give
> it a try, but the config file itself is getting a `line too long`
> error. Is there some way to inject newlines into the index? I tried
> editing the development.sphinx.conf directly, but calling ts:index
> automatically reconfigures overwriting this file. I'd prefer not to
> have to hack on the rake infrastructure since I also use it in a bunch
> of tests.
>
> Any ideas?
>
> --
> 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.
