>
> Results are with firebird 1.5.x
>
> http://benchw.sourceforge.net/benchw_results_open3.html
>
> any opinions ?

A pitty you cannot download the actual data.

For example, the last table holds many rows - yet, the first
query seems rather fast... I guess it boils down to what the
column "dim0.ddate" holds as values as well.

Just for fun, I'm now generating 10000000 rows of data :-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com