[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16171153#comment-16171153 ] 

Alexander Kolbasov commented on SENTRY-1960:
--------------------------------------------

[~btowles] [~spena] [~vamsee] [~lina.li] [~mcrocker] FYI.

> 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
>            Reporter: 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)