Subject | RE: [IBO] Optimize Locate() for an entirely fetched TIB_Query result set |
---|---|
Author | Support List |
Post date | 2011-05-12T21:00:41Z |
Thomas,
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/
=======
> > Even with the settings above, I still have a large number (pretty muchSure, I'd be glad to.
> > 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?
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/
=======