Enabling pooling with entitydac

Discussion of open issues, suggestions and bugs regarding EntityDAC
Post Reply
darnocian
Posts: 5
Joined: Sun 23 Aug 2020 11:07

Enabling pooling with entitydac

Post by darnocian » Sun 23 Aug 2020 11:43

I'm using EntityDAC with UniDAC and postgres.

On UniDAC, it is clear as to how to use pooling - just enable the property...

However, on EntityDac using the TEntityConnection, I'm not sure.

Any advice on how to do this without recreating connections every time?

Maybe by overloading one of the factory methods for creating a connection, which could use a pooled TUniConnection?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Enabling pooling with entitydac

Post by MaximG » Wed 26 Aug 2020 14:50

EntityDAC doesn't support connection pooling. You can leave your suggestions at our UserVoice page (https://devart.uservoice.com/forums/240996-entitydac), and if there are many votes for your suggestion, we will implement it.

claudio.piffer
Posts: 48
Joined: Mon 30 Apr 2007 07:36

Re: Enabling pooling with entitydac

Post by claudio.piffer » Tue 05 Jan 2021 14:39

Hi darnocian

if you use UniDAC you can enable the pool directly in the creation of the UniDACConnection.

I include the EntityDAC.DataProvider.UniDAC.pas source in my project and I changed the

constructor TUniDACConnectionProvider.Create(DataProvider: TDataProvider);

setting the FUniConnection.Pooling := True (I also set MinPoolSize/MaxPoolSize properties)

Best Regards

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Enabling pooling with entitydac

Post by MaximG » Wed 06 Jan 2021 17:01

Yes, you can use this approach with pooled connections.

Post Reply