workflow performance issue or not?

[prakashkumarill]

Hello experts!!!!!!

when several workflow instance is in process and waiting for a document status change to occur, will it be a performance issue?

I have a scenario in which my workflow is triggered when a document is created, it goes through statuses from 1 to 10 (for ex). Most document will only reach status 7. Is it a good idea to design a workflow which will complete when the document reaches status 7 or there will not any performance issue if the workflow waits for document status to go the stage 10 for its completed.

your thoughts and suggestions are apreciated

Thanks

Prakash

[morten_nielsen · Accepted solution]

Hi

If all these workflow's are waiting for changes that will occur almost simultaneously - the yes, you could be facing a performance issue, (depending on the load and the sizing of your landscape).

If the flows are triggered using events, I would recommend you to use the event queue. You can find documentation on how to use / Setup here http://help.sap.com/saphelp_47x200/helpdata/en/17/1adc37d4edec12e10000009b38f8cf/frameset.htm

Even if your not facing a performance issue, the event queue is still a very good idea, as it can help stabilize your solution. e.g. in case of at error in your workflow, you can mark the event, in the event queue as having an error. The queue will then continue to collect the event, without triggering your workflow.

When you then have fixed the bug, you can reactivate the event queue, and no event will have been lost.

Regards

Morten Nielsen

[pokrakam · Accepted solution]

Hello,

Events with errors land up in the event queue regardless of whether you use it or not.

I don't completely understand the scenario - but if you're talking about workflows starting and waiting for events that never happen - that's not a good idea. Good design is to ensure your flows complete at some stage, as active workflows are ones that will impact performance more than completed ones. Use some condition or even a long deadline (a month or longer?) to ensure your workflows complete.

Cheers,

Mike

[prakashkumarill]

thanks everyone for your help. i was modeling the workflow to trigger when a document is created(at this stage the workflow status is in IN PROCESS) and wait for conditions which is change of document status, to procede further till it reaches the last status.

Now i am thinking that it will be a good idea to start the workflow whenever the document status is changed and complete the workflow for one status change.

please reply if you have any suggestions.

[pokrakam]

Hello Prakash,

Both scenarios are valid - it depends on your business case. What is the primary goal of your workflow? Are you concerned with the individual status processes or is your WF supposed to manage the whole status chain or

If the latter then your original scenario is ok, but make sure your process completes.

What are the criteria for your document to stop at status 7 or 10? Use the same to terminate your Workflow process.

Cheers,

Mike