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