[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