Connection Pool

Reginaldo · Post by **Reginaldo** » Sat 09 May 2009 22:17

Hi, does anybody know how to set up a connection pool using DBX Driver for PostgreSQL (via dbxconnections.ini + dbxdrivers.ini or via code)?
I'm using Delphi 2009 + Devart PostgreSQL DBX4 Driver (sigle developer licence) + PostegreSQL 8.3 and I have 1 TSQLConnection per remote server, but if I have dozens of client apps connected to the server, I think I should have to pooling my SQLConnection.

Thanks in advance,
Reginaldo Francisco - |Brasil

Plash · Post by **Plash** » Wed 20 May 2009 09:06

You can enable the connection pooling in the following way:

Set the Driver property for TSQLConnection component in Object Inspector. Click on the plus sign beside the Driver property. You will see two subproperties: DelegateName and DelegateConnection. Select DBXPool for the DelegateConnection property. This will enable pooling. Then you can open subproperties for DelegateConnection, and edit properties of the connection pool.