[ https://issues.apache.org/jira/browse/SENTRY-1960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexander Kolbasov reassigned SENTRY-1960: ------------------------------------------ Assignee: Alexander Kolbasov > Use DB auto-increment for incrementing table IDs > ------------------------------------------------ > > Key: SENTRY-1960 > URL: https://issues.apache.org/jira/browse/SENTRY-1960 > Project: Sentry > Issue Type: Improvement > Components: Sentry > Affects Versions: 2.0.0, 2.1.0 > Reporter: Alexander Kolbasov > Assignee: Alexander Kolbasov > Labels: sentry-ha > > We noticed that the way package.jdo is configured, it uses DataNucleus > sequence table to maintain keys for table IDs. For new tables we should use > datastore-based identity which is much more efficient. > For example, setting > {code} > <datastore-identity strategy="identity"> > <column name="PATH_ID"/> > </datastore-identity> > {code} > {code} > <datastore-identity strategy="identity"> > <column name="AUTHZ_OBJ_ID"/> > </datastore-identity> > {code} > noticeably improve performance for saving full HMS snapshot in DB. -- This message was sent by Atlassian JIRA (v6.4.14#64029)