Database heavy query caused by QueryableNotificationUsersImpl

Fixed in

EPiServer.CMS.Core 11.20.3

Created

Nov 26, 2020

Updated

Jan 15, 2021

Area

CMS Core

State

Closed, Fixed and tested


Description

QueryableNotificationUsersImpl.FindAsync is used to find users based on their username, not by exact match, but by pattern match. This will basically do a full scan on AspNetUsers table.

If a customer has many users registered, it can be a major bottleneck.