Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

Process Area Launch View should be enhanced to evaluate DataServicesRepository efficiently

DSW.dbo.webProcessAreaLaunchVer takes over 60 seconds to launch at my current client (AHR).  There are no obvious indexes to be added.  We have 7 total rows (users), 857 targets, and 15 objects.

 

When removing the table and logic to calculate the column - DataServicesRepository, the view returns instantly.  

Either the evaluation should be improved to return more promptly, or an alternative view could be used (such as the attached view) when DataServices is not in use.

  • Guest
  • Jun 20 2017
  • Future consideration
  • Jun 20, 2017

    Admin response

    What version are you on?

  • Attach files
  • Guest commented
    June 20, 2017 14:28

    6.5.3 - June 4 2016