search

HangfireIO / Hangfire

An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
https://www.hangfire.io
Other
9.35k stars 1.69k forks source link

Sql Server Push model: event notification #1143

Open cveld opened 6 years ago

cveld commented 6 years ago

Currently Hangfire uses a polling strategy with SQL Server in order to get the latest state. This makes it a less attractive provider compared to e.g. Redis.

I am wondering whether it would be possible to implement a SQL Server based push model using the event notification mechanism?

Also see https://social.msdn.microsoft.com/Forums/vstudio/en-US/3e77e604-c5bb-43f4-b966-b221894ee007/stepbystep-guide-to-get-notifications-in-c-when-a-sql-database-table-changes?forum=csharpgeneral

iSatishYadav commented 6 years ago

Can you use MSMQ? Have a look http://docs.hangfire.io/en/latest/configuration/using-sql-server-with-msmq.html