Subject Re: [IBO] Optimize Locate() for an entirely fetched TIB_Query result set
Author Thomas Steinmaurer
Jason,

>>> Even with the settings above, I still have a large number (pretty much
>>> the number of Locate() calls) of
>>>
>>> SELECT * FROM IBLM$COLUMNLOGDEF
>>> WHERE IBLM$COLUMNLOGDEF.TABLE_NAME=? /* BIND_0 */
>>> AND IBLM$COLUMNLOGDEF.OPERATION=? /* BIND_1 */
>>> AND IBLM$COLUMNLOGDEF.COLUMN_NAME=? /* BIND_2 */
>>>
>>> calls. In the Firebird 2.5 Trace API output.
>>
>> I have a simple sample application with a smallish Firebird 2.5
>> database, which shows this problem. Care to have a look?
>
>
> Sure, I'd be glad to.

Have you had time to give it a try?

Thanks,
Thomas