Hi Luis It wouldn't be too tricky to use Riddle to query Sphinx directly - AR models are only queried for the sake of string facets (and that's something I'm looking at working around when I implement facets in my rewrite of Thinking Sphinx).
Feel free to give it a shot, but if you get stuck let me know and I'll piece some code together to help. Cheers -- Pat On 06/08/2012, at 5:36 PM, Luis Lavena wrote: > On Saturday, August 4, 2012 1:24:39 PM UTC-3, Pat Allan wrote: > Hi Luis > Sorry for not responding sooner. Unfortunately, I can't think of any way to > do this - there's no way to refer to other indices or have subqueries within > queries. Not saying what you want to do is impossible… but certainly, I've no > idea how to do it. > > > > Thank you Pat, > > I figure out a workaround by using Facets tags(:id) on the post: > > class Post > define_index do > # ... > has tags(:id), :as => :tag_ids, :type => :multi > end > end > > And combined with some scopes, I was able to retrieve the accumulated tag_ids > from it. > > But, while I got the results from Sphinx pretty fast, iterating over search > bundle and collecting the counters takes considerable amount of time, leaving > me in the same situation as first scenario. > > I'm thinking use a C extension to iterate over the search results and extract > the sphinx attributes, but haven't figure out all the details yet. > > Perhaps there is a way to collect these sphinx attributes without looping > through? maybe use Riddle directly instead? > > While looking into this, some colleagues comment to me that ElasticSearch > gives you indexed terms ordered by usage when you do a query, but those terms > can't be paginated (which is something I need too). > > I'll keep investigating into this and if I find an alternative will post it > here for others. > > Thank you again for your time, > -- > Luis Lavena > > > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/dyfIrSkUj60J. > 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.
