| Subject | Re: Usage of SPs? |
|---|---|
| Author | Adam |
| Post date | 2005-09-28T23:55:19Z |
--- In firebird-support@yahoogroups.com, Sándor Tamás (HostWare Kft.)
<sandortamas@h...> wrote:
application with full functionality, and see what SPs are used.
you). You could find a tool that extracts the SP code. That would be
my first step. You could then write a procedure that finds the word
after "ALTER PROCEDURE" (the procedure name), then inserts some string
immediately following the next begin, then run the script.
Adam
<sandortamas@h...> wrote:
> I see your point. But we have almost 600 SP's, and I think that someof 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?Yuck. Those shortcuts always come back to haunt you (or someone after
you). You could find a tool that extracts the SP code. That would be
my first step. You could then write a procedure that finds the word
after "ALTER PROCEDURE" (the procedure name), then inserts some string
immediately following the next begin, then run the script.
Adam
> ----- Original Message -----from a
> 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
> > 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]