performance issue on submit #193

Closed
opened 2025-10-27 18:18:50 +00:00 by allan · 0 comments
Owner

Submitting a change was taking a long time to reach the next screen. It turned out that the getchangeinfo service was querying the MPE_AUDIT table, which had grown to 51gb

Adding an index to MPE_AUDIT fixed the problem

We also discovered that the mpe_checkrestore macro was not using dynamic audit values from MPE_TABLES

Submitting a change was taking a long time to reach the next screen. It turned out that the `getchangeinfo` service was querying the MPE_AUDIT table, which had grown to 51gb Adding an index to MPE_AUDIT fixed the problem We also discovered that the mpe_checkrestore macro was not using dynamic audit values from MPE_TABLES
allan closed this issue 2025-12-08 11:25:44 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: dc/dc#193