在Rails中加速查询

我正在开发一个Rails应用程序，该应用程序可以为将在页面上呈现的单个查询提供20-30k条记录。我很感激对这个问题的反馈，谢谢！

控制器

def index
  if params[:advertiser].blank?
    @products = Product.all
  else
    @advertiser_name = Advertiser.find_by(name: params[:advertiser]).name
    @products = Product.where(advertiser: @advertiser_name)
  end
end

Product对象具有所有记录，可以通过广告商名称进行查找。

查看

<div class="product-listing">
  <ul>
  <% @products.each do |p| %>
    <li id="name">Product Name: <%= p.product_name %></li>
    <li id="advertiser">Advertiser: <%= p.advertiser %></li>
    <li id="designer">Designer: <%= p.designer %></li>
    <li id="price">Price: <%= p.price %></li>
    <li id="commission">Commission: <%= p.commission %></li>
    <li id="url">Url: <%= p.product_url %></li>
    <hr>
    <% end %>
  </ul>
</div>

当前负载时间

Completed 200 OK in 35531ms (Views: 31808.9ms | ActiveRecord: 3689.6ms)

向你们展示我的模式可能会有所帮助。

ActiveRecord::Schema.define(version: 20151227085753) do
create_table "advertisers", force: :cascade do |t|
  t.string   "name"
  t.datetime "created_at", null: false
  t.datetime "updated_at", null: false
end
create_table "products", force: :cascade do |t|
  t.string   "product_id"
  t.string   "product_name"
  t.string   "product_url"
  t.string   "advertiser"
  t.string   "designer"
  t.string   "price"
  t.string   "commission"
  t.datetime "created_at",   null: false
  t.datetime "updated_at",   null: false
 end
 add_index "products", ["advertiser"], name: "index_products_on_advertiser"

结束

@products_with_details = Product.joins('inner join advertisers on product.advertiser_id = advertisers.id')
  .joins('inner join designers on product.designer_id = designers.id')
  .select('
    product.name as product_name,
    designers.name as designer_name,
    advertisers.name as advertiser_name
  ').all