Optimize Admin::Registrations::GroupsController#create query performance
The core problem is in your Admin::Registrations::GroupsController#create action. When creating both a group and project together, you're triggering a cascade of database operations:
- Group creation with all associations (namespace, route, settings, features, etc.)
- Member creation and authorization updates
- Project creation with its full set of associations
- Notification settings, webhooks, security settings, and more
Currently, the query limit is disabled for this endpoint as a temporary measure to allow the feature to work. This issue tracks the optimization work needed to reduce the number of database queries triggered during group and project creation.
The quickest fix was to disable the query limit for this specific endpoint, but we should optimize the underlying operations to reduce unnecessary queries and improve performance.