Branch: refs/heads/master
Home: https://github.com/openSUSE/open-build-service
Commit: 90ba8fad05613819f5f8483b102fccd9072d75ad
https://github.com/openSUSE/open-build-service/commit/90ba8fad05613819f5f848...
Author: Sumit Jamgade
Date: 2020-05-26 (Tue, 26 May 2020)
Changed paths:
M src/backend/BSFileDB.pm
M src/backend/bs_repserver
Log Message:
-----------
[backend] Speedup jobhistory route by 4-6x
This is a two part change. But put together to allow context to the next
change.
This patch allows fdb_getall_reverse to return undecoded line to filter.
This raw line can be filtered out earlier without the need of decoding
over the layout.
This is useful for large and long maintained projects. Projects
(Factory, Devel..) have a long build history, decoding every
line in the jobhistory file only to be filtered out based on filter
conditions (package type, result code, buildtimes) is expensive. This
patch facilitates skipping those costs reach the result faster.
Tested on IBS/SUSE:FACTORY:HEAD/standard/i586/MozillaThunderbird
without patch:
100 results: 6 sec
1000 results: 53 sec
with patch:
100 results: 1 sec
1000 results: 13 sec
Commit: d6a52f8899a910c1b3c5164ed6abe08aa225ea6f
https://github.com/openSUSE/open-build-service/commit/d6a52f8899a910c1b3c516...
Author: Sumit Jamgade
Date: 2020-05-28 (Thu, 28 May 2020)
Changed paths:
M src/backend/BSFileDB.pm
M src/backend/bs_repserver
Log Message:
-----------
Merge pull request #9577 from sjamgade/filedb_raw_jobhistoy
[backend] Speedup jobhistory route by 4-6x
Compare: https://github.com/openSUSE/open-build-service/compare/250a6b8b155a...d6a52f...