Task #512
closed
Audit for users is slow
100%
Description
In our project we currently have 44000 items in "Audit for users". Loading one page with 10 items/page takes about 1 minute.
Entity audit works without problems.
Related issues
Updated by Ondřej Kopr over 7 years ago
This behavior is known, There is no simple way to show audit information with relation for identities for now (there is 4 queries with relation -> this cant be pageable :( )
I will inform you about the progress.
Updated by Ondřej Kopr over 7 years ago
- add 6 new columns into table IDM_AUDIT (owner_type, owner_id, owner_code, sub_entity_type, sub_entity_id, sub_entity_code),
- actual IdmAuditIdentityService will work with these columns,
add this workaround for now only for Identity and relations?
Updated by Ondřej Kopr over 7 years ago
- % Done changed from 0 to 60
- IdmIdentity,
- IdmIdentityRole,
- IdmIdentityContract,
- AccIdentityAccount,
- IdmIdentityFormValue.
Audit for user is now faster, for quick filter is search only in IdmAudit table.
Updated by Ondřej Kopr over 7 years ago
- Status changed from New to Needs feedback
- Assignee changed from Ondřej Kopr to Vít Švanda
- % Done changed from 60 to 90
Also fixed (temporary solution) fill attribute changed columns. If I create and edit one entity in one transaction, fill attribute changed columns is not terminated by an error - add tests.
Please Vitek could you make a review and test audit for identity via FE, thank you.
Commit (own branch):
https://github.com/bcvsolutions/CzechIdMng/commit/1708701e6d6b17446af6bc62ebf5e177c88a9666
Updated by Ondřej Kopr over 7 years ago
- Related to Task #447: Audit log - add filter for user, find relations, translate IDs added
Updated by Ondřej Kopr over 7 years ago
- Related to Defect #518: audit for entity - detail corrupted added
Updated by Vít Švanda over 7 years ago
- Status changed from Needs feedback to Resolved
- Assignee changed from Vít Švanda to Ondřej Kopr
- % Done changed from 90 to 100
Works fine, review notes in #477.