We have created a Ruby on Rails website which is based on searching a
table of 70,000+ object. Each object searched then returns a list of
id’s in another table, of about 30,000. The id’s are listed for each
object in the first table.
The problem is, when we search for object which are very frequently
met, the query runs extremely slowly, and after looking at the query
log, seems to be made up of a number of OUTER JOINS.
If anybody has any idea how to optimize this kind of query, feedback
would be greatly appreciated.