IntelliTect / IntelliTect.AspNetCore.SignalR.SqlServer

A Microsoft SQL Server backplane for ASP.NET Core SignalR.
Apache License 2.0
39 stars 5 forks source link

Retention policies for data purging #12

Closed yp3y5akh0v closed 1 year ago

yp3y5akh0v commented 1 year ago

Is there any automated process that can be used in here to purge old data (payloads) for hub tables ?

ascott18 commented 1 year ago

No, there is nothing beyond the automatic deletion when the tables exceed 10,000 rows.

Are you looking for a duration-based purged process (e.g. to fulfill legal data retention requirements)?

yp3y5akh0v commented 1 year ago

I see, so tables are always maintain the same size to prevent memory leaks, I was originally thought I could pass number of days and once it got passed retention policy, data will be purged.