Database Size Getting Out Of Control
I work for a large NHS Trust in the UK and we are using Healthshare and we process 1000s of messages each day. Many of these are standard HL7 messages however for several months now we also pickup and drop off 1000s of PDF files.
We have our message purge set to 365 as we have to keep a years worth of messages as we have a retrieval and send process that enables us to replay any set of messages to any destination which we use to prepopulate end systems with activity and result history.
The issue we have is our database is growing out of control and I am not sure the best way to remediate this situation.
Is there a way that I could setup a custom purge to get rid of some of the stream data within the database? I realise that I could move the PDF pickup and drop off projects to another production however and decease the purge on the new production however that will only decrease the main production day by day over the next 12 months.
Any suggestions would be greatly received?