Subject Re: Usage of SPs?
Author Adam
--- In firebird-support@yahoogroups.com, Sándor Tamás (HostWare Kft.)
<sandortamas@h...> wrote:
> Hi,
>
>
> Is there any possibilities to find out which procedures are used from a
> database in a time interval? Let's say like a counter or something?
>
> SanTa

No.

It would be rather trivial though to create a table to store that
information and modify the stored procedure to add a record to it.
Always insert ('SP_Name', 1) into the table, do not run "update .. set
cnt = cnt + 1 where name = 'SP_Name'", because this will prevent the
SP calls from occuring simultaneously.

Basically, this method is an efficient way of counting

http://groups.yahoo.com/group/firebird-support/message/56457

Adam