Branch: refs/heads/master
Home: https://github.com/openSUSE/open-build-service
Commit: b0d7d263bee0b355ed2127d1660c1af1a9724c6f
https://github.com/openSUSE/open-build-service/commit/b0d7d263bee0b355ed2127...
Author: Stephan Kulow
Date: 2017-12-11 (Mon, 11 Dec 2017)
Changed paths:
M src/api/app/models/event/request.rb
Log Message:
-----------
[api] Fix huge bottleneck in notification emails
The way source_watchers and target_watchers were implemented was pretty
suboptimal. It took >20 seconds to dig out 128 users watching
openSUSE:Factory by going through the WatchedProject objects connected
to these 128 users and listed the users for these, which resulted in
128x128 SELECT user ... - but all we want is the list of 128 User
objects (to filter subscriptions for them)
So the new query results in one SQL statement taking the database a
friction of a second
Commit: ccda0573426bf6adb2f57e3b00a0ab1cb566ecb9
https://github.com/openSUSE/open-build-service/commit/ccda0573426bf6adb2f57e...
Author: Ana María Martínez Gómez
Date: 2017-12-11 (Mon, 11 Dec 2017)
Changed paths:
M src/api/app/models/event/request.rb
Log Message:
-----------
Merge pull request #4200 from coolo/optimize_watcher_query
Fix huge bottleneck in notification emails
Compare: https://github.com/openSUSE/open-build-service/compare/4e6efd8ae499...ccda05...