Task #939
closed
Add index for audit tables
100%
Description
Add index for necessary audit tables.
More information can be found there: https://wiki.czechidm.com/priv/navrh/1muzivatelu
This ticket will be part of 8.0.0 version
Related issues
Updated by Ondřej Kopr almost 7 years ago
- Target version changed from Garnet (7.8.0) to Hematite (8.0.0)
Updated by Ondřej Kopr almost 7 years ago
- Status changed from New to Needs feedback
- Assignee changed from Ondřej Kopr to Radek Tomiška
- % Done changed from 0 to 90
With distinct problem I found solution in ticket: https://hibernate.atlassian.net/browse/HHH-5372
Also I added new Idm audit strategy for Idm. The strategy check if is modified only modified attribute and then skip or continue with auditing (this was hardest part of this ticket) Something about strategies: https://docs.jboss.org/hibernate/envers/3.6/reference/en-US/html/configuration.html#config-audit-strategy
Alse change behavior for changed columns.
Also I added new indexes:- revchanges(rev),
- idm_role_request(applicant_id),
- idm_role_request(state).
Please Radek could you made a review?
commit: https://github.com/bcvsolutions/CzechIdMng/commit/d5277bf00d25f98e330d4b7a1bd0bd65066225f3 (develop)
Updated by Ondřej Kopr almost 7 years ago
- Target version changed from Hematite (8.0.0) to Garnet (7.8.2)
Updated by Ondřej Kopr almost 7 years ago
- Related to Task #972: Slow synchronization of Identities added
Updated by Radek Tomiška almost 7 years ago
- Status changed from Needs feedback to Closed
- Assignee changed from Radek Tomiška to Ondřej Kopr
- % Done changed from 90 to 100
I did test and review, it works and code is nicer than before :) thx.