I am new to thinking sphinx and it's taking too long to index my
database.
I currently have 16 works and I am indexing work.name, work.info,
work.credited_users.name and work.credited_titles.name. Sphinx is
taking around 37mins to index 16 works. And I can't imagine how long
it will take when I deploy my project and the number of works
increase.

Am I doing something wrong?

my Work model looks like this:

  has_many    :credits, :dependent => :destroy
  has_many    :credited_users, :through => :credits, :source => "user"
  has_many    :credited_titles, :through => :credits, :source =>
"title"

  define_index do
    indexes :name
    indexes info
    indexes credited_users.name, :as => :credited_user_name
    indexes credited_titles.name, :as => :credited_title_name
  end

I am working on a MacBook 2.4GHz Core 2 Duo with 2GB RAM

Here is my indexing stats:

Sphinx 0.9.8.1-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff

using config file '/Users/.../config/development.sphinx.conf'...
indexing index 'work_core'...
collected 16 docs, 0.0 MB
collected 0 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 16 docs, 1820 bytes
total 2228.265 sec, 0.82 bytes/sec, 0.01 docs/sec
distributed index 'work' can not be directly indexed; skipping.

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

Reply via email to