Project

General

Profile

Patch #22850

Updated by Toshi MARUYAMA almost 8 years ago

<pre> 
 Environment: 
   Redmine version                  3.2.2.devel 
   Ruby version                     2.1.5-p273 (2014-11-13) [x64-mingw32] 
   Rails version                    4.2.6 
   Environment                      production 
   Database adapter                 Mysql2 
 SCM: 
   Git                              2.8.1 
   Filesystem 
 Redmine plugins: 
   no plugin installed 
 </pre> 

 I made an optimalization to avoid these queries, that reliably kills the application if there are many member roles. 

 SELECT `member_roles`.* FROM `member_roles` WHERE `member_roles`.`inherited_from` = ? 

 

     This table was retrieved with a full table scan, which is often quite bad for performance, unless you only retrieve a few rows. 
 
     The table was retrieved with this index: 
 
     No index was used in this part of the query. 
 
     You can speed up this query by querying only fields that are within the index. Or you can create an index that includes every field in your query, including the primary key. 
 
     Approximately 1224500 rows of this table were scanned.

Back