DNNCommunity / DNNCommunity/DNN.Events

When clicking Add event, module times out and aborts.

Open
#252 5 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
27
Forks
39
PR merge metrics
No merged PRs in 30d

Description

## Please summarize your question in one sentence
When attempting to display the add page, the process performs sql stored procedure(s) (aspnet_Membership_GetUserByName, and more) for every user on the system. Is this how version 7.00.07 works?

## Give a more extended description
When attempting to display the add page, the process performs sql stored procedure(s) (aspnet_Membership_GetUserByName, and more) for every user on the system. We have over 92,000 users and the system will timeout and abort at just over record 7100. This occurred after the DNN upgrade to 9.10.06 and Event module v. 7.00.07. We did not have this issue before the upgrade.

## Steps to reproduce (if needed)

## Other comments or remarks

Contributor guide

Open the contributing guide

Research direction

No source files or tests are named. Start by reproducing the Add event page with DNN 9.10.06 and Event module 7.00.07 while tracing the SQL procedures, especially aspnet_Membership_GetUserByName, across a large user base. Done should mean the page no longer times out while loading and the unnecessary per-user database work is addressed.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
backend, databases, performance
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.