The thing is I'm mainly looking to ensure that TS correctly uses :include to
avoid N+1 queries... I don't think sphinx_scopes help with that...
I guess I could use search_for_ids... but don't you also have to do:
@collection = @collection.collect do |item|
@collection[ids.index(item.id)]
end
to ensure that the order of the results is preserved?
Alternatively, this works:
with_scope(:find => {:include => ...}) do
Model.search(...)
end
In that case, Sphinx respects the scope when it preforms the find on the
ids.
On Wed, Feb 23, 2011 at 5:52 PM, Clemens Kofler <[email protected]> wrote:
> I've used search_for_ids successfully in the past like so:
>
> ids = Model.search_for_ids(... whatever ...)
> @collection = Model.active.published.whatever.find(ids)
>
> The alternative, as was mentioned, is to use sphinx_scope and/or
> handle some of that stuff in the index itself. You can, for instance,
> choose to only index posts that have published = true if that makes
> sense in your business rules (e.g. if the search isn't used in the
> backend where you also list/search for unpublished posts).
>
> - C.
>
> On Feb 23, 11:11 pm, Aaron Gibralter <[email protected]>
> wrote:
> > Is this still the case? It seems like named_scope is ignored as of
> 1.4.3...
> > but how about the v2 branch? Does TS support dynamic arel queries?
> >
> > I could see why conditions, orders, and limits would be ignored... but
> it's
> > tough not being able to include includes to avoid N+1 queries... what's
> the
> > best way to do it? search_for_ids then pass those to a named_scope find?
> > with_scope seems to work too...
>
> --
> 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.
