Does Hangfire work with Memory Optimized tables in SQL Server (In-Memory tables). I’ve seen 500% performance improvements putting low record count and high insert/delete tables In-Memory for other applications. The locking is different for In-Memory tables which may cause problems.
This would be really not too smart to implement because all job status information would be lost after a SQL Server reboot.
You can make memory optimized tables durable.
Craig, you should try it. I’d love to know if you have success or not.
@craig how did you go with conversion to memory optimized tables?