in WAL pattern (write after log) to increase durability and reduce lost risk in high TPS apps, first we append data to reliable source (sql-server) then feed it to hangfire to process data.
the problem is our flow is:
append->fetch->queue to hangfire->insert
(DB->app->DB)
does exist any way to instead fetch rows from db, just give pointer or id list to hangfire?
or even better DB to DB speak with hangfire? (but keep its monitoring capacity)