Slow queries when reading a large data set from the CMR database

Description

Migrated from NovaTec Jira. Original ticket: INSPECTIT-1121

The SprIT team has a big problems with loading data that comes from the database with queries lasting more than 10 seconds . It relates to all data types (HTTP, Timers, System data). The database size is not too big (cca 1.3GB)

The provided me with the DB, so I will test with same database on my machine to make sure that problem is not system related.

If problem is our DB I propose including this ticket to the 1.6.2 and think of some kind of database data aggregation system.

Environment

None

Assignee

Ivan Senic

Reporter

Stefan Siegl

Labels

None

Integrator

None

Components

Priority

High
Configure