James- Thanks. That does work. I had tried something like that before and didn't get it working. It threw me off because I didn't see the join syntax in my dev log. But, I tried that and sure enough my queries are gone and the time has been decreased 10X when the N queries aren't in the cache. Awesome....
Erik On Apr 22, 10:59 pm, James Healy <[email protected]> wrote: > erik wrote: > > This is probably dead simple, but I'm not sure how to do it. Is there > > something I put in my C.search .... call that will modify the > > resulting mysql query to do this automatically? > > I'm not sure there's any way to get TS to do what you want in a single > MySQL query, however the search() method supports the :include option, > similar to activerecord. > > This *should* reduce the queries somewhat: > > C.search("blah", :include => [:a, :b]) > > -- James Healy <jimmy-at-deefa-dot-com> Thu, 23 Apr 2009 15:56:48 +1000 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
