Purge Account UTXO table once an input is spent

[samuelmanzanera]

Is your feature request related to a problem?

All the inputs are currently store in memory.
In order to scale, you should evict the spent transaction outputs from the ETS tables and store them on disk for a later query.

Describe the solution you'd like

After each transaction replication, you are notifying the previous shards for a new transaction in the chain.
Hence, the UTXO are flagged as spent.
We could then at this time delegates to a permanent storage on disk to reduce the footprint of the ETS tables.

Additional context

No response

[internet-zero]

Hey team! Please add your planning poker estimate with Zenhub @samuelmanzanera @Neylix @apoorv-2204