Page 1 of 1

How many component to use with one TZConnection?

Posted: 20.03.2006, 22:50
by AndGaG
Greetings.

I am using about 30 components (TZQuery and ZTable), and wanted to know if its correct that I uses only 1 TZConnection component,
and if this does not affect the performance of my application in Delphi 7. Thanks. :roll:

Posted: 20.03.2006, 23:36
by mdaems
Well,

If the queries are not executed simultaneously I would not expect performance problems. For simultaneous queries probably more connections could help. On the other hand, if you use transactions, it's better to have 1 connection, as different connections do not see each others updates until a commit has been executed.

So generally I think your solution is alright, unless you can avoid that many components by reusing them. (Modifying queries in runtime or using parameters)

Does anybody disagree?

Mark

Posted: 21.03.2006, 17:40
by zippo
I agree :)