# Bug OP-16545 - High DB load caused by date alert background jobs

Project: OpenProject
Status: closed
URL: https://community.openproject.org/work_packages/OP-16545

## Open points

_No work packages_

## Details

| Attribute | Value |
| --- | --- |
| Date |  |
| Priority | Medium |
| Module |  |
| Target versions | 15.2.1 |
| Observed in versions |  |
| Sprint | 15.2.1 |
| Backlog bucket |  |
| Bug found in version (deprecated) |  |
| Found in mobile app version |  |
| Follow-up feedback e-mail |  |
| Requires doc change | No |
| Accessibility | No |
| Pull preview |  |
| List |  |
| Labels |  |

## People

| Attribute | Value |
| --- | --- |
| Assignee | Markus Kahl |
| Accountable |  |
| Product manager |  |
| Developers |  |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Planning

| Attribute | Value |
| --- | --- |
| Relevance |  |

## Costs

| Attribute | Value |
| --- | --- |
| Votes |  |
| Work |  |
| Labor costs |  |

## Description

### Steps to reproduce

1.  Have a larger dataset:
    
    1.  1 m+ work packages
    
    2.  50k+ users

2.  Have all users in the same time zone and configured to receive date alerts.

### What is the buggy behavior?

  - A high database load over some hours impeding other requests.
    
      - See also <mention class="mention" data-id="60856" data-type="work_package" data-text="#60856">#60856</mention>

### What is the expected behavior?

  - An acceptable database load
