• rstone - Thursday, December 28, 2017 10:36 AM

    We have one application with a poorly performing security implementation.  Does anybody have any guidance on the performance impact of RLS on a query?  Is it easy to avoid or mitigate performance issues?  

    This is a function, really a CROSS APPLY type function added to your queries. If there are indexes, I wouldn't expect there to be much impact from normal query performance. However, YMMV. I'd certainly like to see more people test this at higher scales with specific queries.

    If we can get  this site upgraded to 2017, I'd like to implement some RLS just to see.