DNNCommunity / DNNCommunity/DNN.Events
When clicking Add event, module times out and aborts.
- 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
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