search

microsoft / durabletask-mssql

Microsoft SQL storage provider for Durable Functions and the Durable Task Framework
MIT License
87 stars 32 forks source link

Inquiry: Limits on Orchestration Instance's History #125

Open mthelen-taslar opened 2 years ago

mthelen-taslar commented 2 years ago

Hi,

Does the MS SQL Provider for DTFx impose a limit on the number of history records (dt.History table) for an orchestration instance? Is it possible to configure one?

Specifically I'm wondering what mechanisms are in place to avoid a never-ending orchestration from browning-out our service's database.

Thank you!

cgillum commented 2 years ago

This is a good question. There is no limit, currently, that's built into the SQL provider or DTFx. If you're using Durable Functions, there is a limit of 100K history records that exists independent of the backend storage provider you choose.

For users using DTFx directly, I think this needs to be considered as a feature request.