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 --------------------------------- Relax. Yahoo! Mail virus scanning helps detect nasty viruses! -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060206/aef59d7f/attachment.html
Check out Ferret: http://wiki.rubyonrails.org/rails/pages/HowToIntegrateFerretWithRails Supa'' Fast ! On 2/6/06, softwareengineer 99 <softwareengineer99@yahoo.com> wrote:> > 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 > > ------------------------------ > Relax. Yahoo! Mail virus scanning<http://us.rd.yahoo.com/mail_us/taglines/viruscc/*http://communications.yahoo.com/features.php?page=221>helps detect nasty viruses! > > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060206/4b4689f5/attachment.html
softwareengineer 99
2006-Feb-06 23:44 UTC
[Rails] Searching large tables with Rails? Ferret works with :3000 but not otherwise??
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 Stamat <dylans@gmail.com> wrote: Check out Ferret: http://wiki.rubyonrails.org/rails/pages/HowToIntegrateFerretWithRails Supa'' Fast ! --------------------------------- Relax. Yahoo! Mail virus scanning helps detect nasty viruses! -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060206/f7b6b2db/attachment-0001.html
softwareengineer 99
2006-Feb-06 23:48 UTC
[Rails] Searching large tables with Rails? It works!
I corrected the permission and it works. Yay! Thanks Frank softwareengineer 99 <softwareengineer99@yahoo.com> wrote: Thanks Dylan. I installed and it works great except that I cannot access it via httpd. On :3000 it works fine. --------------------------------- Yahoo! Mail - Helps protect you from nasty viruses. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060206/79d9058b/attachment.html
Dylan Stamat
2006-Feb-07 17:09 UTC
[Rails] Searching large tables with Rails? Ferret works with :3000 but not otherwise??
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. On 2/6/06, softwareengineer 99 <softwareengineer99@yahoo.com> wrote:> > 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 Stamat <dylans@gmail.com>* wrote: > > Check out Ferret: > http://wiki.rubyonrails.org/rails/pages/HowToIntegrateFerretWithRails > Supa'' Fast ! > > > ------------------------------ > Relax. Yahoo! Mail virus scanning<http://us.rd.yahoo.com/mail_us/taglines/viruscc/*http://communications.yahoo.com/features.php?page=221>helps detect nasty viruses! > > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060207/a603babc/attachment.html