Thanks for the info Pat, I am using fixtures indeed. Fahri
On Sep 4, 4:18 pm, Pat Allan <[email protected]> wrote: > Hi Fahrio > > Are you using fixtures for your data? The way Rails generates ids > slows down Sphinx significantly (indeed, it should be a matter of > seconds for 16 records). > Have a look at the second topic on this > page:http://freelancing-god.github.com/ts/en/common_issues.html > > -- > Pat > > On 04/09/2009, at 2:39 PM, fahrio wrote: > > > > > > > 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 -~----------~----~----~----~------~----~------~--~---
