Subject Re: [ib-support] Repost - Size of Optimizer Block exceeded
Author Helen Borrie
At 10:32 PM 25-07-02 +0000, you wrote:
>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 -
>How can I increase the size of the Optimizer Block or what mitigating
>steps can I take to prevent such an occurrence.

It's not something I have ever heard of as configurable. It's not
something I have ever encountered in 7 years with InterBase/Firebird and
three years with IBO...but it sounds like a message you would get when your
SQL plan is too large to fit in the buffer allocated for it. The cure for
that would not be to increase the size of the buffer but to improve the plan.

So, far, you haven't supplied any comprehensible information about the SQL
you are trying to perform. Once you provide that, we'll have something to
work on...

Use the IB_monitor to capture the PLAN and include that, too, please.


All for Open and Open for All
Firebird Open SQL Database · ·