Project

General

Profile

Refactor #10583

Run .uniq in database instead of in memory when possible

Added by Tomer Brisker almost 8 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tomer Brisker
Category:
Performance
Target version:
1.9.0
Difficulty:
Triaged:
Bugzilla link:
Pull request:
https://github.com/theforeman/foreman/pull/2400
Fixed in Releases:
Found in Releases:
Red Hat JIRA:

Description

Many parts of the code select rows (or columns) from the database and then run uniq in memory.
In most places, uniq can be run in the database (using `SELECT DISTINCT`) thereby improving performance.

Associated revisions

Revision 0e1c5371 (diff)
Added by Tomer Brisker almost 8 years ago

Fixes #10583 - perform uniq in database instead of in memory when possible

History

#1 Updated by The Foreman Bot almost 8 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman/pull/2400 added
  • Pull request deleted ()

#2 Updated by Anonymous almost 8 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

#3 Updated by Dominic Cleal almost 8 years ago

  • Legacy Backlogs Release (now unused) set to 35

Also available in: Atom PDF