Ruby on Rails Wednesday, June 30, 2010

On 30 Jun 2010, at 16:03, Marnen Laibow-Koser wrote:

Well, fast text searching without switching to MyIsam/Postgres for a 

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 

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

No comments:

Post a Comment