> 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.

Glad that this helps you.

The connection pool doesn't cache the whole connection object that stores
all of the cached metadata information. It only caches the live connection
handle with the database. Therefore, when a TIB_Connection gets a connection
handle from the pool it isn't aware of any other information about it. I
would have to enhance the pool to also cache all of the metadata information
along with it.

Hope this helps,
Jason Wharton
www.ibobjects.com