Project

General

Profile

Actions
Copy link

Refactor #10583

closed

Run .uniq in database instead of in memory when possible

Added by Tomer Brisker over 9 years ago. Updated over 6 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.

Actions
Copy link

Also available in: Atom PDF