If I comment out this the indexing is fast: indexes [ address.street_name, address.postal_code, address.city.name ], :as => :address
> Hi, > > rejeep wrote: > > How long time would you estimate that the indexing would take at a > > 2.4GHz dual core, 3 Gb memory computer that only does the indexing > > job? > > My 3 year old, dual core laptop with a 5400RPM HDD can index 1 500 000 > invoice lines in about 2 minutes. That sure is impressive! > > Because it's been running for a day now and there's 9000 companies > > indexed, which seems horribly slow, right? > > > Can you think of anything that could cause this? > > First things to check: > - do you have indexes on all foreign keys? Would that in my case be address? In that case no index. Should I have an index in the companies table on address, or what? > - are your Primary IDs sequential or spread out? What do you mean by this? > There is a little bit of information on slow indexing on the > website:http://freelancing-god.github.com/ts/en/common_issues.html > > -- James Healy <jimmy-at-deefa-dot-com> Tue, 11 Aug 2009 17:44:14 +1000 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
