Bill,

> We are doing this with PostgreSQL at the moment, they have system
> tables that collect statistics and can be read to extract the
> figures. This is not per query, but a specific test run. At the
> moment we start the database (which clears out the counters) and
> then run the test (approx 2hours) and then we look at the
> statistics. Just wondering if there is something similar we could do
> with Firebird?

Nikolay Samofatov, from my office, had started work on a SQL Trace
feature which would allow for this level of profiling details to be
captured thru a plug-in.

While the work on the engine changes were mostly completed, the work was
unfortunately not finished.


Sean