IRC2 Table only shows two dapps

[nickhessing]

Please find attached the image. It seems like it is not up to date.

Regards,
Nick

[Spl3en]

Have you synchronized your database to the latest block ? The IRC2 table is filled progressively, so it may take a while before you get reach it.

[nickhessing]

No i have not. It is extremely slow (about 1 block every minute). In this pace, i will certainly never ever reach the point where mysql db is filled with all blocks haha. I tried a lot to make my PC faster but still no result. Do you havr any tips?

Thanks.

Nick

[Spl3en]

What is the block height of your Aegis instance ?

It is a known issue, Aegis requires a lot of RAM in order to keep the indexes in memory. For now there is no "easy" fix unfortunately. That being said, I'm pretty sure Aegis can be optimized a lot.
As you can see in the README gif, Aegis was done when the ICON blockchain was less than 500k blocks, I'm not a SQL expert and I may have missed a lot of optimizations for storing much more blocks.

Depending on what you need, you may be interested in using the blockmove Aegis snapshot here :
https://blockmove.eu/downloads/Aegis_BH_9421873.gz
It reaches block height 9,421,873.