Project

General

Profile

Task #512

Audit for users is slow

Added by Jan Helbich over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Audit
Target version:
Start date:
06/15/2017
Due date:
% Done:

100%

Estimated time:
Milestones:

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

Related to CzechIdM - Task #447: Audit log - add filter for user, find relations, translate IDsClosed05/26/2017

Related to CzechIdM - Defect #518: audit for entity - detail corruptedClosed06/19/2017

History

#1 Updated by Ondřej Kopr over 4 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.

#2 Updated by Ondřej Kopr over 4 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?

#3 Updated by Ondřej Kopr over 4 years ago

  • % Done changed from 0 to 60
Add new interface - AuditSearchable for these entities:
  • IdmIdentity,
  • IdmIdentityRole,
  • IdmIdentityContract,
  • AccIdentityAccount,
  • IdmIdentityFormValue.

Audit for user is now faster, for quick filter is search only in IdmAudit table.

#4 Updated by Ondřej Kopr over 4 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

#5 Updated by Ondřej Kopr over 4 years ago

  • Related to Task #447: Audit log - add filter for user, find relations, translate IDs added

#6 Updated by Ondřej Kopr over 4 years ago

  • Related to Defect #518: audit for entity - detail corrupted added

#7 Updated by Vít Švanda over 4 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.

#8 Updated by Ondřej Kopr over 4 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF

Go to top