| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Worklist Performance |
« View previous topic :: View next topic » |
| Author |
Message
|
| steinra |
 Posted: Fri Jul 26, 2002 10:52 am Post subject: Worklist Performance |
 |
|
Apprentice
Joined: 23 May 2002
Posts: 28
Location: USA
|
Are there any good guide lines for tuning worklist performance?
I can have 10,000 + items on a list and the queries are taking quite a while to complete. The criteria is not that complex. Order by priority and create date, or just by create date with a threshold of 25 and owner = 'GROUP' (group work lists). This can take a couple of minutes to complete as the number of work items increase.
Any suggestions would be appreciated.
Thanks!
Randy |
|
| Back to top |
|
 |
| jmac |
| Posted: Fri Jul 26, 2002 1:24 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Randy:
Why would you issue a query that returns 10000 items? Since the result of the query is a transient object, it is likely that once you process a few items, the query will need to be re-issued.
Is there some reason why you can not use the Threshold to limit the number of workitems returned.
Perhaps you could give a little more detail on what you are doing.
The quick answer to your first question is "To keep performance robust limit the number of items that are returned from a query"
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| steinra |
| Posted: Fri Jul 26, 2002 2:17 pm Post subject: |
|
|
Apprentice
Joined: 23 May 2002
Posts: 28
Location: USA
|
I am using a threshold on the worklist configuration of 25 items. But it appears that when you use a sort and a filter that the entire 10,000+ items are read before hitting the 25 item threshold.
I have two worklists.
Sort = priority and create date order. Filter owner = "GROUP" Threshold = 25
sort = create date oder. Filter owner = "GROUP". Threshold = 25.
The users need to work oldest/highest priority items first.
I used to have the activity resolve to a role. There were four users in the role. So in the instance where I had 10,000 instances of that activity there were a total of 40,000 work items. Performance was really bad then. It got really bad when there were 5 users and 25,000 instances.
I switched to using the group worklist concept that IBM sent as an example in the web client. The activity resolves to a group user and the other users have the right to transfer items on and off the group list. So in the example I have 10,000 work items resolved to the GROUP user. But the worklist performance is still really slow.
Once the items are transfered to the users private list then performance if fine. I think that is due the fact the only criteria on the worklist there is a fileter of owner = CURRENT_USER. And owner is one of the index columns on the work_items table.
Thanks for the help!
Randy |
|
| Back to top |
|
|
| jmac |
| Posted: Sat Jul 27, 2002 4:47 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Randy:
Of the 10000 workitems, how many can realistically get completed in one day? All of them?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| steinra |
| Posted: Sat Jul 27, 2002 9:57 am Post subject: |
|
|
Apprentice
Joined: 23 May 2002
Posts: 28
Location: USA
|
I wish they could get them all done in one day.
They are behind in their work. Hopefully with a couple of changes we are going to put in they will be able to keep up, but that is not any gaurentee.
They probably could complete a 1000 of those a day if they were to put enough people to work the items.
Thanks!
Randy |
|
| 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
|
|
|
|
