Monthly data update — May 02
As we started to work on signull.io, we discovered how complex working with crypto data is, in reality. This blog will explain some basic methodology behind signull.io and (hopefully) will be published monthly. In case anything is unexplained or unclear, join our Discord.
Intro
This data update will be shorter than usual. We have decided to focus on reducing technical debt a bit, so we can start engaging more users in the upcoming weeks.
Performance issues
During April, we observed frequent degradation of the app performance. We have quickly discovered what is the root cause of this issue — periodic regeneration (updates) of materialized views (precalculated “table” with data which speeds up database requests). Every spike of CPU and disk usage on the chart below is one update and during every regeneration, the whole database is slowed down.
Unfortunately, fixing this using the current database technology is not simple or maybe even possible so we have decided to change the underlying technology itself. I will not dig into deep technical details, if you are interested to know more about this, let us know over our Discord.
These actions should take few weeks and we believe that we might get better scalability, performance and reliability. I will share the progress of this activity inside the next Monthly data update.
Numbers
We have reached more than 10k tokens available on our platform! This is a great milestone for us and we are constantly increasing this number. The number of market caps has naturally increased too.
In the upcoming weeks, after database “migration” is done, we would like to focus on improving the data source, there are some great challenges. More details will follow in future updates.
As I mentioned above, in case of any questions about our methodology, join our Discord or just try our app :)
