> We encounter that the same select statement fired within our
> embedded SQL Application lasts 20 time compared to the statement
> entered into IBOconsole (which uses dynamic SQL I assume). When an
> explicit PLAN is given - the one which IBOconsole showed me - the
> performance gets still more badly.

In no case embedded SQL should show significantly less performance
than dynamic SQL. In Theory it should be faster due to precompiled SQL
statements.

> As there is no performance monitor within firebird server I used
> Filemon from sysinternals to count the number of disk-I/Os. And
> this led to the number 20 time.

You might have forgotten to shutdown and restart the server between
both test-queries. Else the second run would have significantly less
disk IO due to the database cache.

Please make shure that the effect is based on wrong performance
measurement.

Elmar