Actions
Bug #26676
closedSetting initialization is very inefficient and generates a lot of SQL queries
Difficulty:
Triaged:
No
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
Updated by The Foreman Bot about 6 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/6708 added
Updated by The Foreman Bot about 6 years ago
- Pull request https://github.com/theforeman/foreman/pull/6737 added
Updated by The Foreman Bot almost 6 years ago
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/6902 added
Updated by Ondřej Ezr over 5 years ago
- Precedes Bug #27815: Setting initialization improvement added
Updated by Ondřej Ezr over 5 years ago
- Precedes Refactor #27816: Setting initialization improvement added
Updated by Ondřej Ezr over 5 years ago
- Precedes Refactor #27818: Setting initialization improvement added
Updated by Ondřej Ezr over 5 years ago
- Precedes Refactor #27819: Setting initialization improvement added
Updated by Ondřej Ezr over 5 years ago
- Precedes Refactor #27820: Setting initialization improvement added
Updated by Ondřej Ezr over 5 years ago
- Precedes Refactor #27821: Setting initialization improvement added
Updated by Ondřej Ezr over 5 years ago
- Precedes Refactor #27863: Setting initialization improvement added
Updated by Tomer Brisker over 5 years ago
- Subject changed from Setting intialization is very inneficient and generates a lot of SQL queries to Setting initialization is very inefficient and generates a lot of SQL queries
Actions