Create database indexes for AUDIT_ENTITY_LOG table

jmix-framework / jmix

Jmix framework

https://www.jmix.io

Apache License 2.0

693 stars 124 forks source link

Create database indexes for AUDIT_ENTITY_LOG table #3896

Open Gavrilov-Ivan opened 2 days ago

Gavrilov-Ivan commented 2 days ago

Add indexes for table AUDIT_ENTITY_LOG - it can contain huge amount of records but doesn't provide any indexes to improve search for data. Suggested fields:

USERNAME
EVENT_TS
CHANGE_TYPE
ENTITY
XXX_ENTITY_ID

glebfox commented 5 hours ago

Migration script should be executed optionally.