Does SqlTrackingService update the database at each workflow event?

I am tracking workflows by SqlTrackingService. However, I found out that SqlTrackingService does not update my SQL dababase until the workflow instance is completed (or terminated). Is that true If yes, is there any way to let SqlTrackingService update the database at each workflow event

Thanks.



Answer this question

Does SqlTrackingService update the database at each workflow event?

  • Helenyeap

    For the SqlTrackingService - set its IsTransactional property to false. It still does transactional writes - but it means it doesn't wait till a Transactional save point of the workflow (like the end if you aren't using a persistence service).

  • Svetlana Loksh

    You can configure the persistence service to save your workflow state when the workflow goes idle (waiting for an event or timer) by setting the UnloadOnIdle property to true. You can set this using the constructor or add it as an attribute in the configuration file depending on how you are adding your services.

    matt



  • zuhx

    That's it.

    Thanks! ;-)


  • Heba El-Sherif

    Thanks Matt.

    But I am using only the Tracking Service. In order that workflows can be tracked when running, do I have to add the Persistence Service


  • Does SqlTrackingService update the database at each workflow event?