> 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