Page 1 of 1

Better Performance - Single TMyConnection or Many?

Posted: Thu 27 Mar 2008 10:05
by ACS2000
Hi,

I'm using Delphi Win32 and use DataModules for most of my major forms.
I'm wondering whether to use a single TMyConnection that all the DataModules access or to put a connection in each one. I'm trying to make each Form/DataModule to be as independent as possible, but I'm worried about memory and network load.

Your advice would be appreciated.

Alan

Posted: Fri 28 Mar 2008 07:50
by Dimon
If you use connection with the same parameters for each DataModule, it's better to use one TMyConnection. Otherwise all depends on your application specificity.
Also you can use connection pooling. You can find detailed information about it in the "Using connection pooling" topic of MyDAC help.

Posted: Tue 01 Apr 2008 14:27
by ACS2000
Thanks will look into the pooling