Oof- I was afraid of that. Well, I think I can enhance your existing formula of (id * index types) to include the # of tenants (id * index type * #tenants); I'll play with that.
I'll also have to change the grouping to be (id, tenant_id). Should be pretty straightforward - fingers crossed. Thanks again, Eric On Sep 4, 12:08 am, Pat Allan <[email protected]> wrote: > Hi Eric > > Sphinx does require unique document ids across an entire setup - it presumes > documents in different indices are the same object if they have the same id. > > Perhaps in your situation it'd be better to have multiple Sphinx daemons? > That way each daemon (and it's configuration file) can deal with their own > set of document ids. > > Cheers > > -- > Pat > > On 04/09/2011, at 8:02 AM, Eric wrote: > > > > > > > > > Hi- > > > I was looking at the method in thinking_sphinx.rb: > > > def self.unique_id_expression(adapter, offset = nil) > > "* #{adapter.cast_to_int context.indexed_models.size} + #{offset > > || 0}" > > end > > > It appears from this that sphinx would like the id attribute to be > > unique across all indices. Is this true? I didn't see anything about > > that in the sphinx spec. > > > PS. I'm looking into the notion of a composite ID for a multitenant > > platform, so trying to find out if there is a cross-model unique ID > > requirement in sphinx, or if the ID merely needs to be unique with a > > particular model. > > > Thanks, > > Eric > > > -- > > 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 > > athttp://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.
