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.
How many component to use with one TZConnection?
Moderators: gto, cipto_kh, EgonHugeist, olehs
How many component to use with one TZConnection?
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.
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.
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
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
