Optimization of attestation storage #24
Description
Good day,
I have been hosting an instance of Stellar Lab on my Docker stack for around 3 weeks now. As it kept running and accumulating attestations from the other members of the network, I noticed how quickly the database started bloating in size. My instance currently has 248501 attestations recorded, which take up around 112MB of storage.
I took a peek at the layout of the database tables and what data they contain, and I saw a lot of repeated UUIDs, public keys and signatures. I believe there is a lot of storage saving possible by optimizing how the data is referenced and reused. It may also be more efficient to store signatures and public keys in binary blob format over BASE64 text, but I'm unsure how well this would mesh with the rest of the codebase.
Unfortunately my knowledge regarding SQL is rather limited, so I can only make rough observations regarding this issue and how to fix it, but I believe there is potential for storage usage reduction and even minimal performance improvements.