Some of these "limits" boggle the mind. I can understand a limit dealing with
4294967296/2147483648 at this point in the game, but where does 48k come from?

Jason

Helen Borrie wrote:

> At 04:18 PM 10/01/2006 +0000, you wrote:
>> I came accross, on an application I'm starting to support with the
>> following error message:
>>
>> ISC Error Code 335544762
>> ISC Error Message
>> size of optimizer block exceeded.
>>
>> Does anyone has some more information about this error? I couldn't
>> find any information on what may be causing it or on how to deal with
>> it.
>
> It means the plan exceeds the limit of 48Kb. The only way to reduce it
> will be to rewrite the query so it generates a smaller plan.
>
> ./hb
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.