We're updating the issue view to help you get more done. 

The database scripts do not contain the relevant index definitions

Steps to reproduce

Steps to reproduce:

1. Reports have been reaching the community about databases not performing well anymore due to major amounts of data produced by Matterhorn.
2. Looking at the database scripts, there are many tables that do not define indices, thereby forcing database engines to do massive table scans

We need to review the database scripts and compare them with the SQL queries defined through JPA to determine JOIN conditions, WHERE clauses and other construct that may profit from database indices.

Status

Assignee

Tobias Wunden

Reporter

Tobias Wunden

Severity

Performance

Tags (folksonomy)

Components

Fix versions

Affects versions

1.4.0

Priority

Blocker