[HIVE-24432] Delete Notification Events in Batches

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: David Mollitor
• Reporter: David Mollitor
• Created: 25/Nov/20 20:46
• Updated: 17/Nov/22 08:49
• Resolved: 20/Jan/21 20:20

Description

Notification events are loaded in batches (reduces memory pressure on the HMS), but all of the deletes happen under a single transactions and, when deleting many records, can put a lot of pressure on the backend database.

Instead, delete events in batches (in different transactions) as well.

Issue Links

• links to: GitHub Pull Request #1710