| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Performance Cost of Private Worklists |
« View previous topic :: View next topic » |
| Author |
Message
|
| Bobbo |
 Posted: Tue Jan 27, 2004 12:37 pm Post subject: Performance Cost of Private Worklists |
 |
|
Acolyte
Joined: 17 Jun 2002
Posts: 50
Location: Buffalo, New York
|
What is the performance cost to the system of a Private Worklist? We envision n number of private worklists being created per user. How does this affect the performance of the system? Storage requirements on the database end?
Thanks.
Bob |
|
| Back to top |
|
 |
| jmac |
| Posted: Tue Jan 27, 2004 12:54 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Bob:
As I understand it, the only cost is going to be the database space, and I never seen anything published as to how much space it takes up... But I would doubt it is a large amount. Esentially any type of permanent list is simply storing the Sort, Filter and Threshold criterea in the DB. The actual query is done against the ExecutionService
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| workflowdude |
| Posted: Wed Jan 28, 2004 7:39 am Post subject: |
|
|
Novice
Joined: 17 Nov 2003
Posts: 24
Location: US
|
| Do all query methods on the ExecutionService hit the database? So what do you mean by persistent objects stored on the workflow server. I see this mentioned at a lot of places in the Programing guide |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Jan 28, 2004 8:14 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
| workflowdude wrote: |
| So what do you mean by persistent objects stored on the workflow server. |
Not sure what you are talking about here. I didn't mention persitent objects.
I will try to answer what I think you are asking:
The queries done against "persitent lists" are actually done against the ExecutionService object in the long run. When you query a list, you don't need to specify threshold, sort, filter... but what actually happens is they get that information out of the database, then do the query "as if" it were done against the execution service object, useing the sort, filter and threshold criteria that were specified for the list.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
