#34: Indexing the results of an nested set ancestry query

on April 15, 2009, 08:59 PM UTC   —   from   148c663fd665c53518538e093ce3c2ab_small kueda    ( 603 views )
I would like to use Sphinx and ThinkingSphinx to index the results of a nested set ancestry query, but I'm not entire sure how. The kind of query I need to do would be something like SELECT id FROM taxa WHERE taxa.lft <= $target_taxon_lft AND taxa.rgt...
Tags: sphinx, indexes, search, ThinkingSphinx, SQL, Rails
0 solutions | 0 references     Add Solution | Add Reference