From 10b3e3e32394216fd8700635e71fd25ea52dfda1 Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Sat, 10 Dec 2016 08:54:20 +0000 Subject: [PATCH] #lock_nested_set very slow on mysql with thousands of subtasks (#23318). Patch by Stephane Evr. git-svn-id: http://svn.redmine.org/redmine/trunk@16053 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- lib/redmine/nested_set/issue_nested_set.rb | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/redmine/nested_set/issue_nested_set.rb b/lib/redmine/nested_set/issue_nested_set.rb index afbe6b995..3d1293dc2 100644 --- a/lib/redmine/nested_set/issue_nested_set.rb +++ b/lib/redmine/nested_set/issue_nested_set.rb @@ -158,7 +158,8 @@ module Redmine self.class.reorder(:id).where(:root_id => sets_to_lock).lock(lock).ids else sets_to_lock = [id, parent_id].compact - self.class.reorder(:id).where("root_id IN (SELECT root_id FROM #{self.class.table_name} WHERE id IN (?))", sets_to_lock).lock.ids + inner_join_statement = self.class.select(:root_id).where(id: sets_to_lock).distinct(:root_id).to_sql + self.class.reorder(:id).joins("INNER JOIN (#{inner_join_statement}) as i2 ON #{self.class.table_name}.root_id = i2.root_id").lock.ids end end -- 2.39.5