Analyze perfomance for timeseriesDB and implement first measures

Refactoring Task

🗻 Summary

We want to reach the performance level that was available with influx DB also with the new database architecture

💣 Why is the current state bad?

Load test for the new timescale DB resulted in longer response times as compared to the previous solution.

🥅 How could that be improved?

Needs to be researched. We focus the research on the Add - Payload thing and not import/export for the moment

For this sprint, we want to implement measures that can safely be concluded in that sprint and add follow-up stories for promising measures that need more time.

💡 Hints

• We should check if we are correctly using batch inserts, because it seems that hibernate disables these (https://www.timescale.com/learn/testing-postgres-ingest-insert-vs-batch-insert-vs-copy, https://www.baeldung.com/jpa-hibernate-batch-insert-update).

🤔 Risks & Open Questions