View Issue Details

IDProjectCategoryView StatusLast Update
0007046OXID eShop (all versions)4.05. Performancepublic2024-06-26 10:35
ReporterSvenBrunk Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status confirmedResolutionopen 
Product Version6.1.4 
Summary0007046: Approximately 95 queries on the database when saving the object rights in the role settings
DescriptionWhen saving the settings under Admin Roles->Objects, about 95 queries are sent to the database to save the settings. Then another 2 dozen queries are sent to read and display the result. 76 of these queries are inserts in oxfield2role with individual field-specific roles, even if the settings were only made at the top level. Perhaps the settings could be saved in a cascaded manner so that reading from the database and saving in it is similar to how it is displayed in the frontend: If there are no adjustments at the lowest level, the one above shows global rights, otherwise "customized". If the "Customized" is actually saved, you could cascade further based on this.
TagsAdmin, Database, Performance and Caching Rework, Rights & Roles
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionNot defined

Activities

QA

2019-11-05 11:09

administrator   ~0013035

-MK