Forum: Ruby on Rails Searching large tables with Rails?

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
softwareengineer 99 (Guest)
on 2006-02-07 00:24
(Received via mailing list)
I have a large table (> 20,000 records)  with text columns for  which I
need to build a search function. Is there a "Rails" way to  index all
the entries and NOT search using LIKE?

  "LIKE" searches  can get very slow and I would rather build an index
of the columns to speed up things.

  Just want to know if there is something like "acts_as_indexable"
available in ROR? Or even a way to quickly create a keyword index?

  I appreciate your assistance very much.

  Thanks
  Frank
Dylan S. (Guest)
on 2006-02-07 00:27
(Received via mailing list)
softwareengineer 99 (Guest)
on 2006-02-07 01:47
(Received via mailing list)
Thanks Dylan.
  I installed and it works great except that I cannot access it via
httpd. On :3000 it works fine.

  Other controllers and action on the same application work fine on
httpd?

  Any ideas what could be causing this?

  Thanks
  Frank

Dylan S. <removed_email_address@domain.invalid> wrote:  Check out Ferret:
http://wiki.rubyonrails.org/rails/pages/HowToInteg...
Supa' Fast !
softwareengineer 99 (Guest)
on 2006-02-07 01:50
(Received via mailing list)
I corrected the permission and it works. Yay!
  Thanks
  Frank

softwareengineer 99 <removed_email_address@domain.invalid> wrote:  Thanks Dylan.
  I installed and it works great except that I cannot access it via
httpd. On :3000 it works fine.
Dylan S. (Guest)
on 2006-02-07 19:13
(Received via mailing list)
Hmm... no clue.  It should work just like any other controller.  I guess
just make sure your /index folder (the one holding the indexes, wherever
you
put them) has the correct permissions... etc.
That's all I can think of.
This topic is locked and can not be replied to.