Question

I ve used 瑞安·比特与Ajax 系列进行搜索,以撰写一些基本搜索功能。

What it basically does is take a string from a form, and performs a like query via a model method. What I m trying to do is conditionally search to different columns(due_date and name) in the database with a single string that I parse with the Date class. That way a user can search for items by a date, or the item name witht he same form. My method looks like:

def self.search(search) 
    if search
      search_date = Date.parse(search) rescue nil
    end

    if search_date
      where( due_date = ? , search_date)
    elsif search
      where( UPPER(name) LIKE ? , "%#{search.upcase}%")
    else
      scoped
    end
  end

如同用户类型在某一日期时一样,该日期的班级能够进行整顿,在数据库中查看任何预定日期的物体。问题在于,如果它是一个日期,它能够 par平,搜查就会缓慢。

我想知道,是否有办法加快这项工作。日期等级是否如此缓慢? 我是否应该有两种不同的方法? 或者,我是否完全改写我的搜寻?

Answer 1

我确实怀疑,它有“条码” 。请查看<条码>log/development.log,看看点执行时间。你最可能经历的是一张表扫描,因为你再次缺乏关于<代码>的索引> 截止日期:。

浏览器通过<代码>EXAMINE对查询进行缓慢检查。例如:

EXAMINE SELECT * FROM items WHERE due_date= 2011-01-01

你们获得一些信息,了解它必须经过的浏览量,以及可以使用的任何指数。

Answer 2

While date-handling in Ruby is notoriously slow, it would not be noticeable for a single call like this...

这很可能是贵国数据库中缺失的一个指数。

检查你被定义为有关表格的索引...... 你们应该这样做:

add_index :my_table, :due_date

Then your database will be able to find the records quickly.

Answer 3

While the previous answers about looking for slow queries and leveraging an index are likely going to get you more bang for you buck, you should also check out Ryan Evan s C implementation of Date/DateTime, the home_run gem.

友情链接