[ 
https://issues.apache.org/jira/browse/SENTRY-2249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16670375#comment-16670375
 ] 

Na Li commented on SENTRY-2249:
-------------------------------

[~kkalyan] can you add the log message to show that your patch has achieved 
batch persisting the path entries? 

Also, do you have datanucleus document that show how to match two classes to 
the same DB table correctly? Your current approach is doing that, and I want to 
make sure the PATH_ID will be generated correctly.

> Enable batch insert of HMS paths in  Full Snapshot.
> ---------------------------------------------------
>
>                 Key: SENTRY-2249
>                 URL: https://issues.apache.org/jira/browse/SENTRY-2249
>             Project: Sentry
>          Issue Type: Improvement
>          Components: Sentry
>    Affects Versions: 2.1.0
>            Reporter: kalyan kumar kalvagadda
>            Assignee: kalyan kumar kalvagadda
>            Priority: Major
>         Attachments: SENTRY-2249.001.patch, SENTRY-2249.002.patch, 
> SENTRY-2249.003.patch, SENTRY-2249.004.patch
>
>
> Currently each entry in full snapshot of HMS is persisted one entry at a 
> time. Instead it could be optimized by persisting the path entries in 
> batches. DB operations are expensive, reducing the number of database 
> operations and around trip time will help. This would decrease the time to 
> persist the snapshot in to database significantly.
> Size of the batch could be configurable.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to