Stream: hapi
Topic: bulk delete data
Katerina Nikolova (Aug 09 2021 at 14:06):
Hello everyone,
we are trying to bulk delete some resources from our HAPI FHIR server - more specifically Coverage resources. We have around 7 million unique records.
The FHIR server is very slow at deleting them - we have tried multiple solutions. We have implemented every performance recommendation available in the docs.
- Expunge - handles about 8000 records per a few minutes (very slow)
- Expunge delete - similar to 1
- We are thinking of updating the records on the database - the res_deleted_at element and expunging the deleted versions - this seems faster
Is there a way to speed up the process or any alternative solution to make the bulk deleting faster?
Last updated: Apr 12 2022 at 19:14 UTC
