[midPoint] MidPoint DB changes
Viliam Repan
vilo.repan at evolveum.com
Sat Jan 6 00:00:45 CET 2018
Hi all,
I”ve just merged some changes related to hibernate 5 upgrade to MidPoint master branch.
These changes will improve write speed of audit records, mainly in cases when there are many records in audit tables.
More performance improvements are on the way as well.
Current changes unfortunately means some DB changes as well. Simplest solution is to drop and recreate tables:
m_audit_ref_value
m_audit_prop_value
m_audit_item
m_audit_delta
m_audit_event
I’ve also created DB upgrade scripts, which do more intelligent version of upgrade as only “id” column has changed.
Now it’s marked as auto_increment/identity column.
Pull requests with improvements for SQL scripts are more than welcomed.
Best regards,
viliam
More information about the midPoint
mailing list