Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

2015-04-16 Thread Tim Ward t...@telensa.com [firebird-support]
On 15/04/2015 18:50, hv...@users.sourceforge.net [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

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

2015-04-16 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, tdw@... wrote : On 15/04/2015 18:50, hvlad@... mailto:hvlad@... [firebird-support] wrote: ---In firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com, listas@... mailto:listas@... wrote : Re: [firebird-support] Re: Plan

[firebird-support] Re: Plan question, what is a stream and what isn't?

2015-04-15 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, tdw@... wrote : If SET STATISTICS is done on one connection, when does it take effect? As any DDL statement it actually runs at transaction commit. What about a transaction that was already running at the time someone else did SET STATISTICS,

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

2015-04-15 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Re: Plan question, what is a stream and what isn't?

2015-04-15 Thread hv...@users.sourceforge.net [firebird-support]
---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