Some comments:

> I have been running come benchmarks comparing Hypersonic, Firebird
> Embedded(Jdbc Type2) and Mysql on the same data set.

The comparison is not really fair. You should use remote Hypersonic server
and type 4 driver, since you connect to MySQL using sockets.

Also, did you use Hypersonic with disk-persistence or memory-only tables?

> Select ID from abc; returning all 75000 integer IDs
> HYPERSONIC = 1.66 sec
> FIREBIRD = 3.46 sec
> MYSQL = 0.2 sec

What is ID? Column a?

Most likely MySQL used index to obtain data. With Firebird this is not
possible - it must check all record versions.

> Select count(*) from abc where J > 500; returning count of 68000
> (index on column J)
> HYPERSONIC = 1.41 sec
> FIREBIRD = 30.26 sec
> MYSQL = 0.06 sec

Firebird must fetch all rows to return count(*), that's the price for MGA
architecture.

> Select count(*) from abc where K > 500; returning count of 55000 (no
> index on column K)
> HYPERSONIC = 1.54 sec
> FIREBIRD = 0.25 sec
> MYSQL = 0.06 sec

Same here, but MySQL seems to be faster anyway...

Roman