rejeep wrote: > > - 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?
You should have an index on the address id in your companies table. Assuming you're following rails conventions, that's probably companies.address_id > > - are your Primary IDs sequential or spread out? > What do you mean by this? Are your company ids and address ids (the primary keys) in ascending order (1, 2, 3, 4, 5, etc) or are there big gaps (1, 1000000, 3000000, etc). If there are big gaps, that can cause slow indexing. The website has some more detail on this. That said, I suspect your issue is no index on companies.address_id -- James Healy <jimmy-at-deefa-dot-com> Tue, 11 Aug 2009 18:40:04 +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 -~----------~----~----~----~------~----~------~--~---
