Converting Hangfire tables to Memory Optimized Tables in SQL Server


#1

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.


#2

This would be really not too smart to implement because all job status information would be lost after a SQL Server reboot.


#3

You can make memory optimized tables durable.


#4

Craig, you should try it. I’d love to know if you have success or not.