da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Questions about connection pooling

Forum List » AnyDAC » v 1.x General English

boitet
User

Fresh Boarder

Posts: 9

Karma: 0

Questions about connection pooling

Posted: 2007/09/17 04:34

Hello,
I am wondering what are the benefits of using ADmanager to pool connections.

Actually, I am currently using my own pooling connection system .
My application is multi-thread, each thread owns its AdConnection, each AD connection is a TstringList item identified by the thread id.

After a few test, it seems to work perfectly, but I would like to get your point of view ...
Do you think using ADManager would be better?if yes what would be the benefits ?
Do I have to expect bugs if i keep using this pooling method ?

Thanks,
Michael

Diman

Admin

Posts: 1478

Karma: 18

Re:Questions about connection pooling

Posted: 2007/09/17 05:10

AnyDAC pooler works with IADPhysConnection instances, but not with TADConnection. TADPhysManager handles few aspects, like a:
- reference counting. He knows when to put IADPhysConnection back into pool;
- startup / shutdown of pool;
- check that connection may be pooled.

You can implement your own pooler for TADConnection instances. There should be no problems, if to implement all carefully.

Regards,
Dmitry

boitet
User

Fresh Boarder

Posts: 9

Karma: 0

Re:Questions about connection pooling

Posted: 2007/09/17 05:55

Thanks for this quick answer,
Michael

Forum List » AnyDAC » v 1.x General English