Thanks for the help! I will have to change a few minor things in the database. Then I'll try to use the index.
On Aug 11, 8:43 am, James Healy <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
