0
kicks
Connection Pooling update
VistaDB has had connection pooling since one of the early betas. I was recently speaking with a user who had some questions and I could not remember the answers, so I looked through the code. I found one property that was not exposed to the public interface, and I decided to take the time to document my finding while it was fresh in my mind.
Take a look in the help file (in Build 50) for a new HOWTO topic on Connection Pooling.
Connection pooling enables your .NET application to recyle a connection a pool of connections that have been previously closed. Once a connection with a particular connection string has been created it is placed in a pool during the Close() operator and an application can then resuse that connection without the expense of rebuilding the entire object. When the application requests a connection an existing object is returned from the set of pooled connections. When the object is closed again it will be added back to the pool for reuse