View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0028120 | mantisbt | performance | public | 2021-03-25 21:08 | 2021-04-04 19:36 |
| Reporter | dregad | Assigned To | dregad | ||
| Priority | normal | Severity | tweak | Reproducibility | N/A |
| Status | resolved | Resolution | fixed | ||
| Product Version | 2.25.0 | ||||
| Target Version | 2.26.0 | Fixed in Version | 2.26.0 | ||
| Summary | 0028120: Improve performance of user_pref_clear_invalid_project_default() | ||||
| Description | This function can potentially work with a large number of records, if the project being processed has been set as default by many users. To reduce the overhead, we should cache the user rows, before checking for access level, this way we execute a single DB query instead of one per user. | ||||
| Tags | No tags attached. | ||||
|
MantisBT: master f380b964 2021-03-25 15:30 Details Diff |
Cache user data when clearing invalid project defaults user_pref_clear_invalid_project_default() can potentially work with a large number of records, if the project being processed has been set as default by many users. Caching all user rows early reduces the overhead, as we execute a single DB query instead of one per user. Fixes 0028120 |
Affected Issues 0028120 |
|
| mod - core/user_pref_api.php | Diff File | ||
