Hi,

> statement execution and getResultSet (inclusive iterating)are
> measured separate. First the statement is executed and then the
> resultset is fetched compare the lines below. Case 1 and case 3 only
> execute getResultset without navigating to the first result while
> case 2 and 4 get the resultset and iterate over all results. The
> times for the statement is independend of the case (1 and 2 or 3 and
> 4) except some jitter because the statements are always identical.

I just checked the code. We do one fetch each time result set object
is created. I will check if this is needed, if not I will delay it
till first next() call.

> This should make no difference in case 2 and 4 because in thes cases
> each database has to deliver all data.

Anyway, in general Firebird seems to be faster than "other DB" in
complex queries :)

Thanks!
Roman Rokytskyy