Project

General

Profile

Patch #23328 » bench-23328.rb

Go MAEDA, 2024-01-03 02:10

 
# frozen_string_literal: true

require 'benchmark/ips'

project = Project.find(1)
members = project.members
puts "members.size: #{members.size}\n\n"

Benchmark.ips do |bench|
bench.report('Redmine 5.1.0') do
users =
members.preload(:principal).select do |m|
m.principal.present? &&
(m.mail_notification? || m.principal.mail_notification == 'all')
end
users.collect {|m| m.principal}
end

# The last version before `preload(:principal)` was added in r15518
bench.report('Redmine 3.2.6') do
members.select {|m| m.principal.present? && (m.mail_notification? || m.principal.mail_notification == 'all')}.collect {|m| m.principal}
end

bench.report('#23328#note-8') do
subquery =
members.select(:user_id)
.where.associated(:principal)
.where('members.mail_notification = ? OR users.mail_notification = ?', true, 'all')
User.where(id: subquery)
end

bench.report('#23328#note-2') do
members.eager_load(:principal).find_each()
.select {|m| m.principal.present? && (m.mail_notification? || m.principal.mail_notification == 'all')}
.collect {|m| m.principal}
end

bench.compare!
end
(4-4/7)