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

[Alexander Kolbasov (JIRA)]

Alexander Kolbasov created SENTRY-1960:
------------------------------------------

             Summary: 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


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)