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