Blas,

Concerning the speed of SELECT statement, it in large parts depends on
the database server as database table design.

Firebird/interbase is not smart enough to use correct index,
especially on the join tables

If the sql/tables not designed properly, the speed is terrible even
you use native tool.

Certainly, there are places needs to be improved in the firebird/java
driver.

jw

--- In Firebird-Java@y..., "Blas Rodriguez Somoza" <blas@p...> wrote:
> Hello Roman
>
> Until now we don't test PostgreSQL but compared with other
databases/drivers, the only problem with FB is in the selects, FB
> takes too much time.
>
> For instance FB outperforms SAPBD on inserts and mixed tests,
but takes 180% the time of SAPDB in the selects. I don't know if
> the problem is in the database kernel or in the communication layer,
but this is perhaps the next thing to review. I don't think it
> is in the driver because the problem exist with FB Driver and with
Interclient.
>