That’s expected at high volume. To speed it up, try narrowing which transactions trigger updates (filters, date ranges, or transaction types). Also stagger processing or move the auto-update frequency from 3 hrs to something more realistic for 500k+ records.