Project

General

Profile

Actions

Bug #8057

closed

Queries on expected reports are really slow with more than 2000 nodes

Added by Nicolas CHARLES over 8 years ago. Updated over 8 years ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

When we have severall thousands nodes, the queries to get expected reports in 3.0+ is too slow

There are two parts to improve, the query itself and the index


Subtasks 2 (0 open2 closed)

Bug #8058: Add indexes on expected reports tableReleasedNicolas CHARLES2016-03-10Actions
Bug #8060: Add migration scripts for indexes creationReleasedNicolas CHARLES2016-03-10Actions
Actions

Also available in: Atom PDF