Hello

There are not universal test results, depending on machines used, versions, tables, way of use, etc the results can be very
different.

The description of the test conditions are included in the JDBC document in etc directory of the Driver.

With those tests Interclient is slower than Type4 in selects, and the distance increase if the connection between the driver and
the server is remote one.

To be able to compare the tests, we need to know more about your tests, mainly the machines used and the tests you do. Can you
give a more detailed explanation?.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "Carsten Schäfer" <ca_schaefer@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Tuesday, June 25, 2002 1:00 PM
Subject: Re: [Firebird-Java] Re: Driver status


> I've a question:
> Is Type4 driver now faster or slower than interclient2 with regard to selects ?
> My tests with the Srcs from last week has shown to me that Type4 ist still much slower with selects than Interclient.
> This can not deal with tabledesign or Firebird-Database because i always uses the same tables and only change the driver.
>
> gruse
> Carsten
>
> ----- 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/
>
>
>