Project

General

Profile

Actions

Patch #33431

open

Better performance for Time entries without issue and activity filters

Added by Alexander Meindl almost 4 years ago. Updated 5 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Performance
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:

Description

At the moment all time entry queries join issue and activities. If there is a large number of time entries and issues, this is a big performance issue.

Some of our customers have more than 500.000 time entries and even more issues. A query without a time filter requires minutes. With this attached patch this improves it to some seconds.

Issue and activity joins are only add, if they are required.

It would be great, to get this in Redmine.


Files

time_query_performace.patch (1.64 KB) time_query_performace.patch Alexander Meindl, 2020-05-11 13:47
time_query_performace_v2.patch (790 Bytes) time_query_performace_v2.patch Alexander Meindl, 2020-05-12 14:49
time_query_performace_v3.patch (591 Bytes) time_query_performace_v3.patch Alexander Meindl, 2020-05-12 16:21
time_query_performace_v4.patch (3.97 KB) time_query_performace_v4.patch Alexander Meindl, 2022-11-24 12:23
time_query_performace_v5.patch (4.03 KB) time_query_performace_v5.patch Alexander Meindl, 2022-11-24 12:35
Actions

Also available in: Atom PDF