Project

General

Profile

Actions
Copy link

Bug #15092

open

Queries to fetch changes are too big

Added by Nicolas CHARLES almost 5 years ago. Updated 6 months ago.

Status:
New
Priority:
N/A
Assignee:
-
Category:
Performance and scalability
Target version:
Ideas (not version specific)
Pull Request:
Severity:
Major - prevents use of part of Rudder | no simple workaround
UX impact:
User visibility:
Operational - other Techniques | Rudder settings | Plugins
Effort required:
Priority:
0
Name check:
Fix check:
Regression:
No

Description

We are fetching changes by chunk of 6 hours, which is quite slow on large database

On same database, loaded, tests show that:
  • fetching by 6 hours chunks take 324s
  • fetching by 3 hours take 122s * 2
  • fetching by one hours take 28s * 6

Related issues 1 (0 open — 1 closed)

Related to Rudder - Bug #15041: The computation of changes by rules, at start of web interface, is quite slow ReleasedNicolas CHARLESActions
Actions
Copy link

Also available in: Atom PDF