Project

General

Profile

Actions

Bug #26676

closed

Setting initialization is very inefficient and generates a lot of SQL queries

Added by Marek Hulán over 5 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Settings
Target version:
-
Fixed in Releases:
Found in Releases:

Description

If you load the application with sql logger enabled, you can see hundreds of queries against Settings table. Nearly all of them are unnecessary, there are multiple problems.

1) we update the setting even if it's definition didn't change (twice)
2) we load every setting individually
3) we check if settings table exists by loading one setting object


Related issues 7 (0 open7 closed)

Precedes foreman-tasks - Bug #27815: Setting initialization improvementClosedOndřej EzrActions
Precedes Ansible - Refactor #27816: Setting initialization improvementClosedOndřej EzrActions
Precedes Foreman Remote Execution - Refactor #27818: Setting initialization improvementClosedOndřej EzrActions
Precedes Boot disk - Refactor #27819: Setting initialization improvementClosedOndřej EzrActions
Precedes Chef - Refactor #27820: Setting initialization improvementClosedOndřej EzrActions
Precedes Salt - Refactor #27821: Setting initialization improvementClosedOndřej EzrActions
Precedes Katello - Refactor #27863: Setting initialization improvementClosedOndřej EzrActions
Actions

Also available in: Atom PDF