Converting Hangfire tables to Memory Optimized Tables in SQL Server


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.