OK, great, I'll check that. But write performance is also poor, and
this wouldn't help that.

David

Leyne, Sean wrote:

> David,
>
> Another thing.
>
> > > Client applications written in what language, and what
> > database objects
> > > (BDE, IBO, etc)
> >
> > Java, JDBC. I am running TPC-B. I don't know what you mean by
> > "database objects"
>
> Please review the statement syntax. Unless the statements have been
> updated, they are most likely written using SQL-89 syntax/format:
>
> SELECT a.{Column}, b.{Column} from A, B where A.Foreign_key =
> B.ID..
>
> Firebird performs best if the SQL-92 syntax/format is used:
>
> SELECT a.{Column}, b.{Column} from A join B where B.ID =
> A.Foreign_key
>
> This same problem was experience by Carlos G.A. when he converted the
> AS3AP benchmark suite for his .Net Provider test suite for the project.
>
>
> Sean
>
> *Yahoo! Groups Sponsor*
> <http://us.ard.yahoo.com/M=249982.3083889.4452939.1728375/D=egroupweb/S=1705115386:HM/A=1524963/R=0/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3083889&prop=egroupweb&pos=HM>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.