|Subject||Re: [firebird-support] Re: SELECT for get the number of contexts|
|Author||Walter R. Ojeda Valiente|
Thank you very much Ann, it's very clear now.
On Sun, Sep 27, 2015 at 5:23 PM, Ann Harrison aharrison@... [firebird-support] <email@example.com> wrote:On Sun, Sep 27, 2015 at 1:37 PM, 'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support] <firstname.lastname@example.org> 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,Ann