Subject Re: [firebird-support] Re: SELECT for get the number of contexts
Author Ann Harrison

On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support] <> wrote:

The only way to know how many contexts a stored procedure has is looking at the source code and counting handly them?

The limit on contexts is per statement, not for an entire stored procedure, trigger, or whatever.  A statement is a SELECT, INSERT, DELETE, or UPDATE.

Each table reference is a context.  So, for example, a reflexive join has more than one context for the same table.  An update with lots of subselects has contexts for each part of the subselect.   A statement that references a view has contexts for every table reference in the view.

So, don't worry about the total number of contexts in a stored procedure, but do worry about the use of complex views in apparently simple statements. 

Good luck,