[SENTRY-1960] Use DB auto-increment for incrementing table IDs

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0.0, 2.1.0
• Component/s: Sentry
• Labels: sentry-ha
• Assignee: Unassigned
• Reporter: Alex Kolbasov
• Created: 19/Sep/17 06:01
• Updated: 24/Jan/18 19:13

Description

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

<datastore-identity strategy="identity">
        <column name="PATH_ID"/>
      </datastore-identity>

      <datastore-identity strategy="identity">
         <column name="AUTHZ_OBJ_ID"/>
      </datastore-identity>

noticeably improve performance for saving full HMS snapshot in DB.