Pat, Is possible to do a specific search wihout a morphology, and with morphology in config file set with metaphone?
Thanks On 14 jul, 04:05, Pat Allan <[email protected]> wrote: > Hi Raphael > > It definitely looks like you need the database index on that column - > something like the following in a migration should do the trick: > > add_index :entry_values, :entry_id > > Give that a shot, let us know if it helps. > > Cheers > > -- > Pat > > On 14/07/2010, at 3:33 PM, Raphael wrote: > > > Without that Field > > > ~/Ruby Projects/ngforms ree-1.8.7 (master) $ rake ts:rebuild > > (in /Users/raphael/Ruby Projects/ngforms) > > Stopped search daemon (pid 865). > > Generating Configuration to /Users/raphael/Ruby > > Projects/ngforms/config/development.sphinx.conf > > Sphinx 0.9.9-release (r2117) > > Copyright (c) 2001-2009, Andrew Aksyonoff > > > using config file '/Users/raphael/Ruby > > Projects/ngforms/config/development.sphinx.conf'... > > indexing index 'database_core'... > > collected 6 docs, 0.0 MB > > sorted 0.0 Mhits, 100.0% done > > total 6 docs, 45 bytes > > total 0.009 sec, 4741 bytes/sec, 632.17 docs/sec > > distributed index 'database' can not be directly indexed; skipping. > > indexing index 'entry_core'... > > collected 57842 docs, 0.3 MB > > sorted 0.1 Mhits, 100.0% done > > total 57842 docs, 272056 bytes > > total 0.729 sec, 373143 bytes/sec, 79334.18 docs/sec > > distributed index 'entry' can not be directly indexed; skipping. > > indexing index 'entry_value_core'... > > collected 254217 docs, 5.3 MB > > sorted 0.5 Mhits, 100.0% done > > total 254217 docs, 5282422 bytes > > total 3.683 sec, 1434192 bytes/sec, 69020.65 docs/sec > > distributed index 'entry_value' can not be directly indexed; skipping. > > total 9 reads, 0.016 sec, 936.7 kb/call avg, 1.8 msec/call avg > > total 32 writes, 0.079 sec, 590.6 kb/call avg, 2.4 msec/call avg > > Started successfully (pid 899). > > ~/Ruby Projects/ngforms ree-1.8.7 (master) $ > > > class Entry < ActiveRecord::Base > > > has_many :entry_values, :dependent => :destroy > > > define_index do > > #indexes entry_values(:value_string), :as => :value_string > > indexes entry_number > > has has_error, created_at, updated_at > > end > > end > > > class EntryValue < ActiveRecord::Base > > belongs_to :entry > > > define_index do > > indexes value_string > > has entry_id > > end > > > end > > > ------- > > > With this field take more than one hour to index... > > > Raphael William Costa > > Telefone. +55 41 8401273 > > Email. [email protected] > > Internet. http://www.raphaelcosta.net > > > Em 14/07/2010, às 00:50, Pat Allan escreveu: > > >> Hi Raphael > > >> How long did an index take without that field? And how long does it take > >> when you add it? Do you have a database index on the entry_id column in > >> the entry_values table? > > >> Cheers > > >> -- > >> Pat > > >> On 14/07/2010, at 12:52 PM, Raphael wrote: > > >>> Hi, > > >>> I have a entry that has many entry_values... > > >>> And i need to get Entries that has a entry_values.value_string for > >>> example. > > >>> Entry.rb > > >>> define_index do > >>> indexes entry_values.value_string, :as => :entry_value_string > >>> end > > >>> But that solution take so long to index in compare to index > >>> entry_value fields... > > >>> Is correct to use like that? or How can i return a Entry in a > >>> EntryValue.search ? > > >>> Thanks in Advance, > >>> Raphael Costa > > >>> -- > >>> 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 > >> 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 > > 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.
