| Author |
Message
|
| koko |
 Posted: Tue Jan 17, 2006 3:50 pm Post subject: static vs Dynamic assignment |
 |
|
Master
Joined: 26 Sep 2003
Posts: 206
|
We have a workflow which has some 40 NOOP steps in it. All this NOOPs have dynamic assignment to Process Starter or Process Administrators.
The DBA found that he sees huge reads on the PERSON table. We have some 300 odd users who have ADMIN privileges. I am wondering it is this fact that WF is trying to resolve who should the NOOP be assigned to and is making such huge reads.
I am trying to assign these NOOPS to a DUMMYNOOPUSER. I would like to know if it might add more load on the system as so many workitems would be all created for this ONE user.
P.s I am also restricting the ADMIN privileges to so few people.
_________________
Thanks
Koko |
|
| Back to top |
|
 |
| kotha |
| Posted: Tue Jan 17, 2006 4:57 pm Post subject: |
|
|
Partisan
Joined: 12 Mar 2005
Posts: 333
|
It depends on how many processes are running everyday and how many active users are in workflow.
If the processes count is less, to avoid the huge read in DB, you can assign one user. Consult the documentation for the load balancing issues. |
|
| Back to top |
|
|
| jmac |
| Posted: Tue Jan 17, 2006 5:05 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I always assign NOOPs to a Dummy User. Specific Person assignment is always fastest.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| hos |
| Posted: Wed Jan 18, 2006 12:40 am Post subject: |
|
|
Chevalier
Joined: 03 Feb 2002
Posts: 470
|
John is absolutely right!
One additional information: for automatic activities (like NOOPs) there is no performance overhead for workitem creation. |
|
| Back to top |
|
|
| koko |
| Posted: Wed Jan 18, 2006 2:06 pm Post subject: |
|
|
Master
Joined: 26 Sep 2003
Posts: 206
|
| Quote: |
| One additional information: for automatic activities (like NOOPs) there is no performance overhead for workitem creation. |
Hos,
Thats my next question. If there is an automatic activity say assigned to "DUMMYUSER", will workflow create any workitem for DUMMYUSER?
Does WF try to do any staff resoulton for AUTOMATIC Activities at all?
_________________
Thanks
Koko |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Jan 18, 2006 3:03 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| koko wrote: |
If there is an automatic activity say assigned to "DUMMYUSER", will workflow create any workitem for DUMMYUSER?
Does WF try to do any staff resoulton for AUTOMATIC Activities at all? |
This is what I think:
No workitem would be created assuming the activity ends normally. If the activity were to go InError a workitem would be created.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
