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,