On 12-7-2012 16:24, Tupy... nambá wrote:

>
>
> Caro "peixinhosdalua",
>
> There is no way to increase such kind of searches in a database, because
> the searches are made line per line, searching inside each line by the
> occurrence of your needed search by displacement of the searching word,
> char by char.....

<snip>

> For this kind of search, there is no tip and no trick to increase the speed.

Agreed with Roberto's (and others') remarks about performance in
SQL/Firebird.

Perhaps you could use a full text search engine like Lucene or Sphinx
for these searches in your database....
See e.g. http://www.firebirdsql.org/en/sphinx-full-text-search/ (don't
know whether it's up to date or not)

Good luck,
Reinier