| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Threshold for Workitems |
« View previous topic :: View next topic » |
| Author |
Message
|
| CHF |
 Posted: Fri May 28, 2004 6:45 am Post subject: Threshold for Workitems |
 |
|
Master
Joined: 16 Dec 2003
Posts: 297
|
Lets say I have 1000 workitems in my Worklist.
How does WF query workitems in the database, in the following scenarios?
1) If I dont have any threshold set up, When I refresh my Worklist, WF does q query for all 1000 workitems, am I right?
2) If I have a threshold set to 10, WF will do a query for only first 10 workitems and return them to the Worklist, am I right?
Please share your ideas.
Thanks
CHF  |
|
| Back to top |
|
 |
| jmac |
| Posted: Sat May 29, 2004 3:37 pm Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
It is my opinion that MQWF always queries and gets all workitems from the database that match the filters, then it sorts, then it returns WI to you based on your threshold.
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| manoj |
| Posted: Sun May 30, 2004 7:38 am Post subject: |
|
|
Master
Joined: 30 Jan 2002
Posts: 237
Location: Virgina
|
John,
I believe with MQ Workflow version 3.4 onwards the threshold is part of the SQL generated. It's true that versions below 3.4 it was taken care by workflow and not the databse (SQL)
_________________
-manoj |
|
| 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
|
|
|
|
