Re: [Firebird-net-provider] Firebird Unicode Text search

[Jiri C. <di...@ci...>]

On 4/12/08, Dean Harding <dea...@dl...> wrote:
> By the way, while that may be *possible*, I wouldn't ever recommend it.
>  You're much better off going with Lucene.NET or something like that and
>  allowing for full-text searching.

Yes. For '%something%' cannot be used index (only for '%something' or
starting with), so it's very slow on big table.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com