[SCB-885] saga alpha event scanner delete duplicate events sql optimization

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: saga-0.2.0
• Fix Version/s: pack-0.3.0
• Component/s: Saga
• Assignee: FuChenGeng
• Reporter: FuChenGeng
• Due: 03/Sep/18
• Created: 03/Sep/18 10:52
• Updated: 04/Sep/18 03:14
• Resolved: 04/Sep/18 03:14

Description

The count of txevents is about 100m. and this sql spend too much time so that the event scanner is blocked.

[SQL]DELETE FROM TxEvent t WHERE t.type = 'SagaEndedEvent' AND t.surrogateId NOT IN ( SELECT MAX(t1.surrogateId) FROM TxEvent t1  WHERE t1.type = 'SagaEndedEvent'  GROUP BY t1.globalTxId);

 

时间: 1308.376s

 

受影响的行: 5

Issue Links

• links to: GitHub Pull Request #287