Subject Re: [firebird-support] Re: Usage of SPs?
Author Sándor Tamás (HostWare Kft.)
I see your point. But we have almost 600 SP's, and I think that some of them are depricated. And the only way to find them is to run our application with full functionality, and see what SPs are used.
At least is there a way to change these SPs all at once with some proc?
----- Original Message -----
From: Adam
Sent: Wednesday, September 28, 2005 1:38 AM
Subject: [firebird-support] Re: Usage of SPs?

--- In, 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


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



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links

[Non-text portions of this message have been removed]