| Subject | Re: [firebird-support] Re: Plan question, what is a stream and what isn't? |
|---|---|
| Author | Tim Ward |
| Post date | 2015-04-16T08:26:33Z |
On 15/04/2015 18:50,
hvlad@... [firebird-support] wrote:
---In firebird-support@yahoogroups.com, <listas@...> wrote :
Re: [firebird-support] Re: Plan question, what is a stream and what isn't?
Note, stored procedures and triggers are prepared\optimized once when
loaded into metadata cache.
Regards,
Vlad
> Just by curiosity, when are SPs/Triggers loaded into Metadata Cache? Right before first execution?
Exactly.
What does "right before first execution" mean? What is the lifecycle of "metadata cache"?
So what's the answer to my question, re a process which keeps a connection open permanently and repeatedly re-runs the same procedures in different transactions? Does it need to drop and recreate the connection in order to take account of any SET STATISTICS done by other people, or not?
-- Tim Ward