This solution is not good in my situation : With the solution : WARNING: sort_hits: merge_block_size=144 kb too low, increasing mem_limit may improve performance sorted 82.8 Mhits, 99.6% done WARNING: duplicate document ids found total 102324 docs, 26518385 bytes
Before : sorted 0.1 Mvalues, 100.0% done sorted 4.9 Mhits, 99.6% done total 5887 docs, 1555240 bytes total 2.205 sec, 705063 bytes/sec, 2668.85 docs/sec indexing index 'product_delta'... On Apr 21, 3:25 pm, Chris Rode <[email protected]> wrote: > Hi > > I have done similar.. I ended up putting > > where 'taxons.taxonomy_id is null or taxons.taxonomy_id = 1' > > This prevents the delimiting of any entries without the taxon join.. I am > not sure if there is a better way though > > Kind Regards > > Chris Rode > > On 21 April 2010 14:03, Kpitn <[email protected]> wrote: > > > > > Hi, > > > I want to do something like this en index definitions : > > > define_index do > > indexes taxons.name, :as => :product_taxon, :facet => > > true, :conditions => { :taxonomy_id => 1 } > > end > > > This thing could be translate into this : > > > LEFT OUTER JOIN `taxons` ON (`taxons`.id = `products_taxons`.taxon_id > > AND taxonomy_id=1 ) > > > Is this possible ? > > > Actually i make this to work : > > define_index do > > indexes taxons.name, :as => :product_taxon, :facet => true > > where "taxons.taxonomy_id=1" > > end > > > But If a product don't have taxon the product is missing ... > > > -- > > 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]<thinking-sphinx%[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 > 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.
