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
To: firebird-support@yahoogroups.com
Sent: Wednesday, September 28, 2005 1:38 AM
Subject: [firebird-support] Re: Usage of SPs?


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





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links








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