--- In firebird-support@yahoogroups.com, "bazarin" <wagner@b...> wrote:

> To a final decision about using or not Firebird I prepared a small
> application with only one SQL doing a reading in a 140000+ records
> table. The SQL is very simple:
> 'select * from palavra where original like '%a' and ordenada not
> like 'a%' and original=ordenada'

Wagner, I don't believe any RDBMS will show good performance on
natural scans of large tables. I can suppose

a) your task requires something like web search engine and full-text
indexed search
b) you did'nt payed enough attention to model of area of
automatization and data structures and try to implement search within
unordered chars instead of conditions on indexed columns of joined
tables which reflects entities and relations in real world.

Best regards,
Alexander.