Thank you, it minimizes the problem. Now the data is extracted from the cache instead of the network. However, I am wondering if there is a way to avoid it completely. I am working with the pool system provided by IBObjects and I understand that the connection is never closed, it is reused. The thing is why IBO needs to reload the metadata information each time that I connect to the database if in reality it is using the same connection that has not been closed.


Thank you

--- In IBObjects@yahoogroups.com, "Support List" <supportlist@...> wrote:
>
> > How can I minimize the metadata exchanged between IBO and Firebird?
> >
> > For example, now I just open a connection and I get:
> >
> > --------
> > SELECT D.RDB$CHARACTER_SET_NAME FROM RDB$DATABASE D
> >
> >
> > SELECT R.RDB$RELATION_NAME
> > , R.RDB$FIELD_NAME
> > , F.RDB$CHARACTER_LENGTH
> > , F.RDB$CHARACTER_SET_ID
> > , F.RDB$COLLATION_ID
> > , R.RDB$COLLATION_ID
> > FROM RDB$RELATION_FIELDS R
> > JOIN RDB$FIELDS F
> > ON F.RDB$FIELD_NAME = R.RDB$FIELD_SOURCE
> > WHERE F.RDB$CHARACTER_SET_ID IS NOT NULL
> > ORDER BY R.RDB$RELATION_NAME
> > , R.RDB$FIELD_POSITION
> > ---
> >
> > Is there a way to avoid it or cache it? I am using a webserver with a
> > connection pool. Each time that I open (reuse) a IBO connection, the same
> > SQL statemet is sent to the server.
>
> Have you tried setting the TIB_Connection.SchemaCacheDir property to a local
> folder that you have read/write permissions to?
>
> Regards,
> Jason Wharton
>