Reputation
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Student
Impact
~545 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Oct
30
comment Applying user-defined fields to arbitrary entities
@HLGEM The problem is with our clients, not the business itself. They operate under some unusual requirements, part of which states that they're not allowed to use any non-vetted software in their production environments. We only just get away with SQL 2008 R2, since they're only officially meant to be using vanilla 2008.
Oct
29
comment Applying user-defined fields to arbitrary entities
@AaronBertrand Sadly the performance of our current approach is horrendous when fetching more than 6 or 7 UDFs, due to the ridiculous number of additional rows produced by JOINs. This gets worse when you try to do any query that involves child entities of two or more distinct entity types and a filter on the UDF value - we end up fetching a gigantic chunk of data and then throw it away in the filter part, because doing it all in one query performs so badly (and often isn't feasible).
Oct
29
awarded  Student
Oct
29
asked Applying user-defined fields to arbitrary entities
Oct
29
awarded  Autobiographer
Oct
29
awarded  Teacher