On 30 Jun 2010, at 16:03, Marnen Laibow-Koser wrote:
Well, fast text searching without switching to MyIsam/Postgres for a
start.
Essentially impossible. You need an index for that. The way to get a
full-text index is to switch to MyISAM or, better, Postgres.
Building a
full-text index in the application layer is poor practice and less
maintainable.
Moral: let the DB do the indexing. If your DB doesn't support the
indexing you need, change your DB -- proper indexing is vital.
... or use a dedicated indexing server like Solr. Depending on the
features you want, having an external indexer can even be beneficial
to your application. I haven't followed this thread all too much, but
you could easily add pluralization to the index record when using
something like Solr.
Best regards
Peter De Berdt
--
You received this message because you are subscribed to the Google Groups "Ruby on
Rails: Talk" group.
To post to this group, send email to rubyonrails-t...@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.