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.
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
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/6708 added
- Status changed from Ready For Testing to Closed
- Status changed from Closed to New
- Pull request https://github.com/theforeman/foreman/pull/6737 added
- Status changed from New to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/6902 added
- Fixed in Releases 1.24.0 added
- Status changed from Ready For Testing to Closed
- Precedes Bug #27815: Setting initialization improvement added
- 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
Also available in: Atom
PDF