1.03-02 Performance and size can be dependent on the Users list

rob_marshall · May 2020

When Users list is heavily used, the number of users added can have a significant impact, be mindful of this and remove model access from any Workspace users when not required

bhill5 · September 2023

then allow user list to have sub-sets…. :-)

DaneClemow · January 31

@rob_marshall What do you define as "Heavily Used"? Is there a # of users that you had in mind, or just the less users the less performance impact so remove as many as you can?

rob_marshall · January 31

@DaneClemow

Good call out on the "Heavily Used" piece…basically, the number of modules the Users list is used in (5 modules, 10 modules, 15 modules, etc) because using the User list creates a ton of cells as well as calculations. Well, if you are keeping your Users list "clean" (deleting users no longer using the model), then that is good…However, if you are not keeping up with your Users List maintenance, then you could have calculations being kicked off that will never be used because the users aren't accessing the model. Essentially, just be careful when using the Users List.

Also, what some people think about doing is creating a "custom" Users list (basically a regular list with Selective Access on it) in order to subset the number of users using certain module functionality. Again, fewer users equals fewer calculations. Next month (teaser alert), this should not be a problem as subsetting on the Users List will be available. As soon as this feature comes out, I will have a document and video explaining how it works.