Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

Database heavy query caused by QueryableNotificationUsersImpl

Fixed in

EPiServer.CMS.Core 11.20.3

(Or a related package)

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.