>> i just setup the default fbtrace.conf with all item to true, but i don't have any usefull informations ...
>>
>> just this when i commit :
>>
>> 0 ms, 1 read(s), 1 write(s), 1 fetch(es), 1 mark(s)
>>
>> ex :
>>
>> -------------------------------------------------------------------------------
>> select
>> IDObj
>>> From
>> desc_blob
>> where
>> IDObj='NOT_EXIST'
>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> PLAN (DESC_BLOB INDEX (DESC_BLOB_IDX))
>> 34 ms
> >
>> select
>> IDObj
>>> From
>> desc_empty
>> where
>> IDObj='NOT_EXIST'
>> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>> PLAN (DESC_EMPTY INDEX (DESC_EMPTY_IDX))
>> 2 ms
>
> Use the following trace config:
>
> <database %yourdatabase%>
> enabled true
> log_statement_finish true
> print_plan true
> print_perf true
> exclude_filter %RDB$%
> time_threshold 0
> max_sql_length 2048
> </database>
>
>
> and replace yourdatabase with a regular expression fitting your
> connect/database string.
>
> This should give you detailed information for each
> EXECUTE_STATEMENT_FINISH event.

Btw, this screencast might be interesting:
http://ts.upscene.com/download/demos/fbtm/fbtm_worst_performing_queries.htm


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/