[jira] [Assigned] (SENTRY-1960) Use DB auto-increment for incrementing table IDs

["Alexander Kolbasov (JIRA)" <ji...@apache.org>]

     [ 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)