System performace Vs No.Of work items

[Mike Gambier]

Hi,

 

Performance around Workflow will always depend on lots of things, not least of which are the relative size and power of your SAP platform, the amount of work to be done and the number of users carrying out the work.

 

If you think 1500 is a big number then 3 MILLION would probably blow your mind...that's what we deal with every day by the way. Like I said the number isn't relevent really.

 

The symptoms you describe are more akin to the selection of data that is being carried out under the hood when a Work Item is executed. I would start looking at what your 'step-2' is actually trying to do and ascertain whether it's the Workflow bit of the step that is struggling (unlikely) or whether the code being executed, probably a SAP FM(?), could be tweaked in some way by some adjustments to the way it is being called or helped along by a database index change (almost certain).

 

Analyse what's going on behind the scenes and look for the real tables or functions that are taking the time. 

 

Odds are it's not really Workflow at fault...

 

Mike GT
 


Date: Fri, 18 Dec 2009 17:58:33 -0800
From: ksharath77 at yahoo.com
Subject: System performace Vs No.Of work items
To: sap-wug at mit.edu






Hi All, I was trying to test the system performance with 1500 work items.
we have workflow that parks invoice with header details(FV60 in Task-1 and sends the invoice document number to step-2 to enter line item details(tcode FBV2, BOR-FIPP).
 
This is going smooth with less number of open work items in inbox(around 500 work items)..But when I created 1500 work items..step-2 is having issues in pulling the document..It says Invoice document is not existing in the system. In transaction SM13(database update request) update query is still in running staus. Document is not updated to the database. Once the update job is completed, Workflow step-2 is working fine.
 
Is 1500 open workitems are killing the performace?   Going forward the client is expecting around 4000 work items a day.. 
 
Do any one of you had similar performance issues before? Appreciate any help..
 
 
Thanks in advance.
 
 		 	   		  
_________________________________________________________________
Got more than one Hotmail account? Save time by linking them together
 http://clk.atdmt.com/UKM/go/186394591/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.mit.edu/pipermail/sap-wug/attachments/20091219/23b6fc7f/attachment.htm