# Bug OP-11635 - Copying projects slow if groups with a lot of users are members in a lot of projects

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

## Open points

_No work packages_

## Details

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

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| 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

_Please write down the steps to reproduce. Try to write down all necessary preconditions (what permissions do you have, are other users involved?). Example:_

1.  Have groups that have a lot of users as their members
2.  Have the groups be members in a lot of projects
3.  Copy one of the projects

### What is the buggy behavior?

_Please describe the bug with as most details as possible. Example:_

*   Copying the project takes very long
    *   If sql statements have a limit on their execution time (e.g. on SaaS), the limit might be exceeded which cancels the statement which leads to the copy job failing completely

### What is the expected behavior?

_Describe how the application should behave like. Example:_

1.  Copying does not fail in this scenario.
2.  The impact of the groups on the overall performance is acceptable. 

###
