search

iconation / Aegis

Aegis is an ICON blockchain database & analyzer
Apache License 2.0
5 stars 0 forks source link

IRC2 Table only shows two dapps #3

Open nickhessing opened 4 years ago

nickhessing commented 4 years ago

image

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

Regards, Nick

Spl3en commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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.