| Author |
Message
|
| mkhadse |
 Posted: Thu Mar 28, 2002 8:41 am Post subject: |
 |
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
From the performance side:
Is there any advantage is creating two execution group having the same flows? Will it improve the performance? All the flows in the execution groups access an external db2 database. Will it cause any deadlock/contention issues and hinder perfromance.
Thanks
|
|
| Back to top |
|
 |
| kolban |
| Posted: Thu Mar 28, 2002 8:43 am Post subject: |
|
|
Grand Master
Joined: 22 May 2001
Posts: 1072
Location: Fort Worth, TX, USA
|
| Performance is an interesting term. If you have idle CPU on your machine then adding extra components to soak up the CPU will improve throughput. Basically, any time that a message flow performs some degree of I/O, be it network or disk, then another message flow could step in an use the CPU while the I/O progresses. This would certainly improve throughput. If you have multiple CPUs then multiple execution groups will allow multiple message flows to run in tandem. |
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Mar 28, 2002 9:31 am Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Thank you for a quick response.
All the flows are using one external db2 database. Will there be any database contention? There are 2 free CPUs on the machine.
|
|
| Back to top |
|
|
| mkhadse |
| Posted: Thu Mar 28, 2002 9:32 am Post subject: |
|
|
Acolyte
Joined: 31 Dec 1969
Posts: 73
|
Grand Master Kolban
I would also, like to know what difference does it make, if we allocate more threads to one execution group or create multiple execution groups with the same flows?
|
|
| Back to top |
|
|
| kolban |
| Posted: Thu Mar 28, 2002 10:00 am Post subject: |
|
|
Grand Master
Joined: 22 May 2001
Posts: 1072
Location: Fort Worth, TX, USA
|
The premise of multiple instancies says that one execution group process will have two threads executing the same message flow concurrently. The use of multiple execution groups says that each flow will run individually in each execution group. In principle, using instancies should be faster since there should be no context switches. In practice, I have heard the reverse since there appears to be locking and blocking of control structures within an execution group.
As for database ... it depends if the flows hit the same rows in the table and the locking and transactional mode of access. ODBC allows multiple concurrent connections to progress in parallel. |
|
| Back to top |
|
|
| harrisjc |
| Posted: Thu Apr 04, 2002 3:35 pm Post subject: |
|
|
Newbie
Joined: 29 Jan 2002
Posts: 3
|
Was there not a Hursley recommendation to use multiple executions groups
instead of multiple threads in a single execution group? |
|
| Back to top |
|
|
|
|
