pimcore / admin-ui-classic-bundle

Other
11 stars 98 forks source link

GridView Performance Degradation with Multiple Roles and Workspaces #700

Open saschabaecher-twocream opened 1 month ago

saschabaecher-twocream commented 1 month ago

Steps to reproduce

  1. Create a user
  2. Create at least 5 roles and assign multiple workspaces to each role
  3. Build a folder structure with several subfolders
  4. Add a large number of objects to the folder structure
  5. Open the GridView
  6. A significant slowdown should be noticeable

Blackfire Results

Roles: 8 Workspaces: 50 (partially duplicated) grafik

As an admin, the process is much faster since workspace queries are not included: grafik

Actual Behavior

The loading times are extremely long and can reach up to 20 seconds or more, depending on the configuration, often leading to timeouts that make the GridView unusable.

Expected Behavior

Faster SQL queries to significantly reduce loading times, avoid timeouts and ensure that the GridView remains usable without long waiting times.

fashxp commented 1 month ago

related to https://github.com/pimcore/pimcore/pull/12776