cardano-foundation / cardano-graphql

GraphQL API for Cardano
Apache License 2.0
262 stars 104 forks source link

Feat/speed up chainfollower #899

Closed Kammerlo closed 2 weeks ago

Kammerlo commented 3 weeks ago

Context

The chainfollower took multiple days to sync the assets. This wasn't practically since the time will likely increase in the future. Additionally it was needed to set the starting point of the chainfollower with two environment variables, which was just seen as a work around. The problem were:

This hindered users to use the background easily without days of syncing.

Proposed Solution

We are saving assets in a local cache and save them batch wise. Additionally I adjusted the insertAssets function to skip already existing assets. Through this solution we are able to remove the check hasAsset for each asset (which takes a few seconds for every asset) Additionally catching errors from the Chainfollower and continuing the chainfollower.

This solution increases the speed on mainnet to 10% Assets per hour + removes the need of the custom starting point.