Hello

The tests don't use indexes, only "select * from <table>".

Those tests try to measure only the select and transfer performance, excluding the join or index select performance.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "jwcanada" <jwcanada@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Tuesday, June 25, 2002 12:48 PM
Subject: [Firebird-Java] Re: Driver status


> 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.
> >
>
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>