Subject Re: [IBO] IBOQuery used over a VPN very slow
Author John vd Waeter
Michael L. Horne wrote:
> Hello,
> I just tried to run my program over a VPN, it worked fine
> until I attempted us open a TIBOQuery. At that time it
> paused for about 2 minutes.
> I opened the SQLMonitor and looked at what was going on
> and it appears that when I am assigning the first
> ParamByName, IBObjects pulls from the database all
> the table and stored procedure names, then all the
> field names, and other stuff.
> Why? - and is there a way to disable or lessen the
> amount of this information pulled?
> I am using a TIBOQuery because I still use QuickReports
> for some Report generation.

It is reading all the database's metadata, the schema.

If you set a schemadir in the ib_connection, schemadata will be cached
and the first query will be as speedy as other queries.