London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

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.