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 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.
>
--
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.
