search for: zonat

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,

Hi, I am not sure if this is a general web question or a Rails specific one but either way, I would really appreciate help and guidance. My application generates quotes. To do so, you start at a page that has the client details. From there you go to a catalog (a link on the quote page) and select the items that are to be in the quote. All the above is working just fine. My problem is that when