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. > 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? - are your Primary IDs sequential or spread out? 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 -~----------~----~----~----~------~----~------~--~---
