| Subject | Re[2]: [firebird-support] SP query plan |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2012-04-20T18:10:10Z |
Hello, Nick!
Friday, April 20, 2012, 7:55:09 PM, you wrote:
NU> so the plan is not stored anywhere in the database that I can access?
it is stored only in server memory when procedure being prepared first
time.
NU> what happens is this regard when some clients reconnect and others don't,
NU> different processes could have different plans?
in InterBase, you can watch tmp$procedures, that are loaded into
memory.
When all users, that called that procedure, disconnects, it's
being freed and new user who called it again will result
procedure load and new plan for it.
Why do you ask about this? you have lot of indices that being updated
much for a short time? Btw, you can check how much index statistics
is being changed by using IBAnalyst.
--
Dmitry Kuzmenko, www.ib-aid.com
Friday, April 20, 2012, 7:55:09 PM, you wrote:
NU> so the plan is not stored anywhere in the database that I can access?
it is stored only in server memory when procedure being prepared first
time.
NU> what happens is this regard when some clients reconnect and others don't,
NU> different processes could have different plans?
in InterBase, you can watch tmp$procedures, that are loaded into
memory.
When all users, that called that procedure, disconnects, it's
being freed and new user who called it again will result
procedure load and new plan for it.
Why do you ask about this? you have lot of indices that being updated
much for a short time? Btw, you can check how much index statistics
is being changed by using IBAnalyst.
--
Dmitry Kuzmenko, www.ib-aid.com