Getting Sitecore Users faster, filtering based on custom property

Question

Need help with the performance issue with sitecore GetUsers Function.

I have 80K sitecore users, and have custom property called "Accounts Assigned" in user profile. I am using pipe delimited in the "Accounts Assigned" property. example: 25909|25920|25670|25089

we are using this query to report the users assigned to particular Account.

Sitecore.Security.Accounts.UserManager.GetUsers().Where(x => x.Profile.GetCustomProperty("Accounts Assigned").Contains("25909"));

This is taking 140 seconds, is there a way to remediate that function,

Answer 1

Sitecore user management is based ASP.Net Membership. ()

The architecture of ASP.Net membership wasn't designed to perform operations that you try to do quickly. How your code will work internally:

1. It will get all users (80K)
2. It will deserialize all profiles (Profiles are saved in a separate table. They are saved in the serialized way for flexibility to add any properties without changing database structure. It causes a trade-off: you can't add database index and quickly query profiles directly from database) (80K)
3. It will get profile property "Accounts Assigned" for each user (80K)
4. It will run .Net search inside string on required value. (80K)

I suggest you rethink your architecture and save values that you need to query in another place. It could be:

• Cache
• Index
• Database (with a proper scheme for quick access)

P.S. I assume that you don't use Sitecore Identity Server as it wasn't mentioned in the question.

Answer 2

Instead can use Domain.GetDomain("domainName").GetUsers() which is much faster than UserManager.GetUsers().

For reference, please have a look at below attached url

https://sitecorecontextitem.wordpress.com/2014/07/28/get-all-sitecore-users-by-domain/

Answer 3

You could implement your own Caching (either sitecore custom cache if you want to see it also on the /sitecore/admin/cache.aspx page or application cache) for the list of users returned by your query, this way you would only run the query once. Then when users are requesting changes to their profile in the website you also add/remove them from the cache created previously.

Where are you using the result of the user query? Are you calling this query in author environment only or also on the public website?

Depending on how and where you are using the list of users and if powershell is installed in your Prod environment you can run a script in your code as described in the post https://blog.najmanowicz.com/2012/04/06/using-powershell-console-for-sitecore-in-your-own-code/. The script would be similar to the one you asked in Sitecore Powershell script to filter the users based on custom roles.