Subject | Repost - Size of Optimizer Block exceeded |
---|---|
Author | moorefg |
Post date | 2002-07-25T22:32:36Z |
Can anyone help?
I am getting the above message in my application. I'm not sure what
to look for and will be happy to give further relevant information if
I know where to look.
The application is failing after a scanning only 125 records and
populating an additional field by referencing through a library
procedure that queries a table in another database using a three
field match. The query table is not large - 600 records or so.
There is a severe degradation in speed towards the end so it seems
that there is a memory implication. The query routine table is
closed after each call.
I'm not sure that it is relevant but I'm using IB Objects -
IB_Query's.
How can I increase the size of the Optimizer Block or what mitigating
steps can I take to prevent such an occurrence.
Francis Moore
I am getting the above message in my application. I'm not sure what
to look for and will be happy to give further relevant information if
I know where to look.
The application is failing after a scanning only 125 records and
populating an additional field by referencing through a library
procedure that queries a table in another database using a three
field match. The query table is not large - 600 records or so.
There is a severe degradation in speed towards the end so it seems
that there is a memory implication. The query routine table is
closed after each call.
I'm not sure that it is relevant but I'm using IB Objects -
IB_Query's.
How can I increase the size of the Optimizer Block or what mitigating
steps can I take to prevent such an occurrence.
Francis Moore