Subject Repost - Size of Optimizer Block exceeded
Author moorefg
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