Is there any mechanism available to a SQLCLR assembly for caching that will still work when the assembly is registered as "safe"?
- The cache needs to be thread-safe, so it can be shared by multiple SQL Server pids.
- The cache needs to be held in memory for performance - tempdb is not fast enough.
- The assembly can't be registered as "unsafe".
See this post on StackOverflow for further details. (Sorry for the cross-post, not sure how else to rephrase the question for this site).