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 astart.
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment