Thanks,

Yes, I thought about setting the schemadir but, I have a
couple of questions about that.

1. If I made changes to the DB, how does the schema know
when it should get a new copy?

2. Why does the IBOQuery pull everything when IB_Query doesn't?

Michael

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of John vd Waeter
> Sent: Tuesday, March 21, 2006 11:27 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] IBOQuery used over a VPN very slow
>
>
>
>
> 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.
>
> John'
>
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> !
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>