Subject Re: [IBO] Performance problem with TIB_Query.Prepare
Author Andreas Pohl
Hallo Andreas Hesse,

> I have a performance problem with TIB_Query.Prepare.
> It needs about 1500ms for a simple query like "select * from table".
> The most time-consuming function is TIB_Row.FillRelAliasInfo.
>
> Any chance to speed it up?

try to integrate schema caching on connection level. For testing
purposes you can use IB_SQL.

Connection with database and preparing queries will speed up (after
second connect not first time!) if you assign a schema dir.

--
Andreas