Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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).

share|improve this question
    
I upvoted the answer on Stack Overflow. There's really nothing else to say about the problem than that. –  Jon Seigel Apr 30 '13 at 20:08
    
What is the size of the data, per SPID, that you plan on caching? I looked at the linked question on S.O. and the example uses Key/Value of foo/bar. Does it need to be a key-value-pair? The question as stated here is not as specific. –  srutzky Apr 5 at 2:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.