Description
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.
Attachments
Attachments
Issue Links
- duplicates
-
SENTRY-2438 Persist HMS paths in batches.
- Resolved
-
SENTRY-2185 Performance Issue: Saving MAuthzPathsMapping should be done in batch for path full snapshot
- Open
- incorporates
-
SENTRY-2476 Optimize deleting specific paths for objects
- Resolved
- is required by
-
SENTRY-2305 Optimize time taken for persistence HMS snapshot by persisting in parallel
- Patch Available
- relates to
-
SENTRY-2553 Auth path is not deleted in db after dropping table
- Patch Available
- links to