Subject RE: [IBO] Optimize Locate() for an entirely fetched TIB_Query result set
Author Support List
Thomas,

> > 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.

Regards,
Jason LeRoy Wharton
www.ibobjects.com






=======
Email scanned by PC Tools - No viruses or spyware found.
(Email Guard: 7.0.0.26, Virus/Spyware Database: 6.17500)
http://www.pctools.com/
=======