WF performance with new 20,000 persisted workflow instances each month

Posted by Nikola Stjelja on Stack Overflow See other posts from Stack Overflow or by Nikola Stjelja
Published on 2009-04-23T06:38:13Z Indexed on 2010/06/18 12:23 UTC
Read the original article Hit count: 395

Windows Workflow Foundation has a problem that is slow when doing WF instances persistace. I'm planning to do a project whose bussiness layer will be based on WF exposed WCF services. The project will have 20,000 new workflow instances created each month, each instance could take up to 2 months to finish. What I was lead to belive that given WF slownes when doing peristance my given problem would be unattainable given performance reasons. I have the following questions:

  1. Is this true? Will my performance be crap with that load(given WF persitance speed limitations)
  2. How can I solve the problem?

We currently have two possible solutions: 1. Each new buisiness process request(e.g. Give me a new drivers license) will be a new WF instance, and the number of persistance operations will be limited by forwarding all status request operations to saved state values in a separate database. 2. Have only a small amount of Workflow Instances up at any give time, without any persistance ofso ever(only in case of system crashes etc.), by breaking each workflow stap in to a separate worklof and that workflow handling each business process request instance in the system that is at that current step(e.g. I'm submitting my driver license reques form, which is step one... we have 100 cases of that, and my step one workflow will handle every case simultaneusly).

I'm very insterested in solution for that problem. If you want to discuss that problem pleas be free to mail me at [email protected]

© Stack Overflow or respective owner

Related posts about persistence

Related posts about workflow-foundation