Subject | Re: [IBO] Optimize Locate() for an entirely fetched TIB_Query result set |
---|---|
Author | Thomas Steinmaurer |
Post date | 2011-06-10T20:32:19Z |
Jason,
Thanks,
Thomas
>>> Even with the settings above, I still have a large number (pretty muchHave you had time to give it a try?
>>> 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.
Thanks,
Thomas