Actions
Bug #36500
closed
Optimize DockerMetaTag query and CV version deletion to run a single invocation of the method
Description
Test performance improvement between current query:
self.where("id not in (?) OR (schema2_id IS NULL AND schema1_id IS NULL)", Katello::RepositoryDockerMetaTag.pluck(:docker_meta_tag_id) + [0]).delete_all
vs
self.where("(id != 0 and id not in (select docker_meta_tag_id from #{Katello::RepositoryDockerMetaTag.table_name})) OR (schema2_id IS NULL AND schema1_id IS NULL) ").delete_all
Also, have this method called once per CV version delete vs once per CV version repo delete to save unnecessary calls.
Updated by The Foreman Bot over 1 year ago
- Status changed from New to Ready For Testing
- Assignee set to Samir Jha
- Pull request https://github.com/Katello/katello/pull/10599 added
Updated by
Updated by Jeremy Lenz over 1 year ago
- Target version changed from Katello 4.9.0 to Katello 4.8.3
Updated by Samir Jha over 1 year ago
- Target version changed from Katello 4.8.3 to Katello 4.9.1
Updated by The Foreman Bot over 1 year ago
- Fixed in Releases Katello 4.10.0 added
Updated by Samir Jha over 1 year ago
- Status changed from Ready For Testing to Closed
Applied in changeset katello|6077a1ecf4221470fe3eaadbf6822477bf6ee707.
Updated by William Clark about 1 year ago
- Target version changed from Katello 4.9.1 to Katello 4.9.2
Updated by The Foreman Bot about 1 year ago
- Pull request https://github.com/Katello/katello/pull/10754 added
Updated by The Foreman Bot about 1 year ago
- Pull request deleted (
https://github.com/Katello/katello/pull/10599, https://github.com/Katello/katello/pull/10754)
Updated by The Foreman Bot about 1 year ago
- Fixed in Releases Katello 4.9.2 added
Updated by David Moore about 1 year ago
- Subject changed from Optimize DockerMetaTag query and CV version deletion to run a single invocation of the method. to Optimize DockerMetaTag query and CV version deletion to run a single invocation of the method
Actions