Subject | Re: Usage of SPs? |
---|---|
Author | Adam |
Post date | 2005-09-27T23:38:47Z |
--- In firebird-support@yahoogroups.com, Sándor Tamás (HostWare Kft.)
<sandortamas@h...> wrote:
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
<sandortamas@h...> wrote:
> Hi,No.
>
>
> 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
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