Project

General

Profile

Actions

Bug #22978

closed

Katello Event Queue db queries need improvement

Added by Partha Aji almost 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Performance
Target version:
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

KatelloEventQueue involves the following operations

1) Pick an event thats not in-progress and mark the rest of the duplicate events below it as "in progress"
2) Do the operation
3) Delete all the duplicates

In a large scale environment where over 10's of 1000s of events (with many duplicates) gets queued up in the EventQueue we need a quicker way to handle all 3

The last part seems to delete 1 event at a time instead of deleting the duplicates en masse

Actions

Also available in: Atom PDF