Subject | Re: [IBO] Performance problem with TIB_Query.Prepare |
---|---|
Author | Andreas Pohl |
Post date | 2007-01-29T12:06:42Z |
Hallo Andreas Hesse,
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
> I have a performance problem with TIB_Query.Prepare.try to integrate schema caching on connection level. For testing
> 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?
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