Devart Forums

Hello support,

I have read some issues regarding connection pooling, but I don't understand the way of pooling.

I have have datamodules with several TMyQuery and TMyTable component.
Now my app starts and first all datamodules open the queries and tables. (It takes some time)

Now I want to start/open all the datasets in a thread. So each datamodule in one thread.

Right now I have one component TMyConnection and set the pooling option to true.
Then I read that I have to create for each thread an instance of TMyConnection with same parameters.
So what does it mean?
and after all datasets are open I can delete the connection?

I found TMyConnectionPoolManager but there are only 2 methods in and I thought that I have to add the connection to the poolmanager which takes care of the connection.

thanks for your help!
Thomas

You should put one TMyConnection object on the each data module and set Pooling to True.
If a new data module is created and there are unused connections in the pool, MyConnection will take a connection from the pool. Otherwise, it will cerate a new connection.

Your are talking from a pool, but where is the pool? Who creates this pool?
Thanks for your help

MyDac is creating and automatically handling the pool

So that means if I put 2 components of TMyConnection in my project and set the pooling = true (All connection settings same) pooling is done already?

Set would be great!

Thanks,
Thomas

Yes, these settings are enough to setup pooling.