How does it go if you increate mem_limit in your sphinx.yml file? The default is pretty small (32MB, I think), so hopefully you've got some spare memory space. 512MB wouldn't be too bad - and keep in mind, this memory usage is for the indexer, not searchd.
http://freelancing-god.github.com/ts/en/advanced_config.html Cheers -- Pat On 22/04/2010, at 12:23 AM, Kpitn wrote: > 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. > -- 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.
