Connection Pool

Connection Pool

Postby 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
Reginaldo
 
Posts: 7
Joined: Sat 09 May 2009 21:46

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for PostgreSQL