Skip to content

Transitional TransitionIn Sets

I’ve been struggling lately with poor SQL performance in a Test environment and I’m pretty sure that has been causing an intermittent problem with objects not transitioning in to Sets and Groups straight away. They all get sorted out when the FIMTemporalEvents job runs overnight – but that’s not very comforting to the testers who are expecting immediate results.

Unfortunately improving the SQL platform hasn’t been an available option to date, so I’ve been looking at other ways I can improve performance around Sets, and started using a “transitional TransitionIn set” in a couple of places. While it’s been very hard to measure the actual impact of this particular change, and I have been making various other refinements as well, the reported incidence of “my object didn’t go active” does indeed seem to have dropped off.

We often have sets that describe when an object is “Active” or “Inactive”. The set criteria to determine this may actually be quite complex. Workflows will typically be triggered on transition in to these sets, probably including one which actually flags the objects as “Active” or “Inactive”. The Active set in particular may be very large and I was seeing multiple incidences of failure to transition in to this set, hence also failure to get marked as Active at the expected time.

So what I’ve done is moved all that complex logic into the following sets:

  • “Objects that should be flagged Active”: Active criteria + Status not ‘Active’
  • “Objects that should be flagged Inactive”: Inactive criteria + Status not ‘Inactive’

Transition in to these sets triggers the “flag as Active” or “flag as Inactive” workflows, at which point the objects transitions straight out, keeping these sets empty most of the time.

The criteria for my actual Active/Inactive sets is then nice and simple:

  • “Active Objects”: Status = ‘Active’
  • “Inactive Objects”: Status = ‘Inactive’

There’s another thing I like about this approach, and it’s kind of hard to explain, but here goes: Various workflows, which may well include notifications, will typically be triggered off those Active/Inactive sets – however the criteria of what makes an object Active or Inactive can change. It can be dangerous to mess with the criteria of large sets – you can inadvertently set off large numbers of set transitions and accompanying workflows. Sure I’d be doing this first in dev/test – but triggering tens of thousands of set transitions in an underperforming dev/test environment isn’t much fun either!

So I like the fact that my big sets here have an unchanging rule, and the only place I need to modify criteria is on the small, “should be flagged” sets. Yes the end result is the same, but starting from modifying a zero-member set is certainly an easier position to predict the size of the change – just preview the set membership before committing!

I’m definitely not saying this is a generally applicable approach but it is something I plan on using now whenever a set has complex criteria, it’s expected membership is very large, and it is used to trigger workflows.

 

Post a Comment

Your email is never published nor shared. Required fields are marked *

Spam comments will be blocked by Akismet

*

Endep online order order buy Endep online purchase Endep online without script buy generic Endep from india buy in Endep uk where to buy Endep without a prescription Endep from canada buy 10 mg Aricept generic Aricept cost order Nizoral no visa Nizoral 200 mg buy cheap Nizoral line Nizoral on line best finpecia online pill Requip Requip free Requip uk Amitriptyline generic buy generic Amitriptyline from india where buy Lisinopril purchasing finpecia with overnight delivery Nizoral online buy saturday delivery buy Nizoral in mo how to buy Cytotec online without a rx order Aricept pharmacy buy Aricept with no prescription (prednisone overnight without prescription|how to order prednisone online without a prescription|prednisone without prescriptions in usa|cheapest prednisone|buy prednisone over the counter|prednisone order online|cheap prednisone online no prescription|buy generic prednisone no prescription|prednisone buy cheap|prednisone generic|prednisone no prescription with mastercard|no prescription generic prednisone|prednisone no prescription needed|prednisone express online|purchase generic prednisone online|prednisone from mexico|prednisone online no prescriptions required from the US|prednisone cheap online canadian pharmacy|canadian generic prednisone no prescription|how to get prednisone online no prescription in 20 days|purchase prednisone online|prednisone generic sale|prednisone buy online without rx|wholesale prednisone|prednisone 40 mg without a prescription|prednisone without rx|prednisone without script|prednisone purchase canada|prednisone cheap online|b buy Amitriptyline no perscription cod Online us Requip how to buy Amitriptyline without a prescription buy line Amitriptyline buy Amitriptyline money buy purchase Accutane 40 mg on line no rx Accutane 40 mg sale order 40 mg Accutane online next day delivery 40 mg Accutane online buy Lisinopril pay cod mail order prednisone|do you need a prescription for prednisone in mexico|cheap prednisone no prescription|buy prednisone australia no prescription|cheapest online indian pharmacy for prednisone or generic|where to buy prednisone|how to buy prednisone without a prescription|buy discounted prednisone online|problems with buying prednisone without rx|buy prednisone online with no prescription|where can i get prednisone|prescribing prednisone tablets australia|buying prednisone online without prescription|where can i buy prednisone without prescriptions|where can i get prednisone without a prescription|prednisone online|buy prednisone 40mg|buy prednisone online made in america|prednisone no prescription needed 40mg|prednisone online purchase|40 mg prednisone|prednisone sale no prescription|UK medication prednisone prednisone buy online|canadian pharmacy prednisone|generic prednisone canada|order prednisone online overnight shipping|I need to order prednisone witho Lisinopril overnight cod prednisone cheap online buy lisinopril without prescription buy lisinopril purchase Premarin cod next day delivery where buy Premarin buy Premarin online free fedex delivery Premarin no rx Metformin buy Metformin canada cheapest place to buy Metformin purchase Metformin online generic 20mg prednisone online finpecia online overnight buy generic Finpecia uk online|Finpecia 1 mg order online|Finpecia generic vs propecia|Finpecia cost australia|buy generic Finpecia uk|purchase Finpecia uk|buy Finpecia online prescription|buy generic Finpecia 1mg|buy Finpecia|Finpecia online australia|buy Finpecia no prescription uk|order Finpecia 1mg|buy Finpecia cheap|Finpecia generic 1mg|Finpecia online prescription|Finpecia 1mg generic canada|Finpecia costco pharmacy|Finpecia 1mg india|Finpecia generic walmart|buy Finpecia no prescription forum|buy Finpecia online australia|Finpecia online uk) buy finpecia cheap legal buy Finpecia online online|buy cheap Finpecia online|order Finpecia|Finpecia generic walmart|Finpecia online prescription|buy Finpecia 1mg online|Finpecia generic online|Finpecia costco price|order Finpecia online|buy Finpecia 1mg malaysia|purchase Finpecia uk|topical Finpecia buy|Finpecia 1 mg order online|Finpecia generic|buy Finpecia online canada|Finpecia 1 mg order online|Finpecia online india|Finpecia generic 1 mg|order Finpecia uk|Finpecia depression women|buy cheap Finpecia 1mg|Finpecia generic names|legal buy Finpecia online|Finpecia depression women|buy Finpecia 1mg india|Finpecia generic walmart|buy Finpecia 1mg online|Finpecia online india|buy Finpecia 1mg online|Finpecia 1mg tablets|Finpecia costco price|order Finpecia canada|buy Finpecia online australia|Finpecia dose hair|buy Finpecia online paypal|Finpecia 1mg|Finpecia 1mg for sale|Finpecia online uk|buy Finpecia uk|Finpecia 1mg vs 1mg|Finpecia generic walmart|Finpecia costco pharmacy|buy Finpecia on buy Metformin toronto uk order Metformin Metformin online Metformin prescription buy Metformin where order finpecia canada buy finpecia order Metformin usa online Orlistat buy buy in Orlistat uk buy prednisone topix buy prednisone youtube Orlistat toronto buy discount Orlistat line buy cheap Orlistat without prescription prednisone prescription cost Metformin order online pharmacy Metformin how to buy Metformin without a prescription Metformin price lisinopril buy lisinopril