Subject Minimize metadata using connection pool
Author kokok_kokok
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.

Thank you