feat: speed up key deletion job

eu-federation-gateway-service / efgs-federation-gateway

The goal of this project is to develop the official European solution for the interoperability between national backend servers of decentralised contact tracing applications to combat COVID-19.

Apache License 2.0

59 stars 25 forks source link

feat: speed up key deletion job #295

Closed ascheibal closed 2 years ago

ascheibal commented 2 years ago

Current Implementation

In situations where many keys (> 400k) have to be deleted, DB Systems has longer response times.

Suggested Enhancement

Create an index on created_at column to speed up deletion of entries indentified by this column

Expected Benefits

Faster cleanup times, system keeps more responsive during deletion job.