Subject | Minimize metadata using connection pool |
---|---|
Author | kokok_kokok |
Post date | 2011-11-29T15:32:42Z |
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
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