Connection Pool

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Posts: 7
Joined: Sat 09 May 2009 21:46

Connection Pool

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

Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

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.

Post Reply