bazarin schrieb:

> I expected that Firebird could deal with concurrent requests in the
> same table doing a very good conflict(lock) administration, but
> that's something I am not convinced to.

Conflicts should never be a problem for concurrent reads. The problem
of your test is that that each query forces the DB to load 140.000+
rows from disk - this does take time. Doing this several times does
take more time. You might get better performance if the database can
be held completely in RAM - but that's not the solution you are
looking for.

Elmar