SubQuery TeamAlrededor de 2 min


How to start at a different block height?

Video guide


By default, all starter projects start synchronising the blockchain from the genesis block. In otherwords, from block 1. For large blockchains, this can typically take days or even weeks to fully synchronise.

To start a SubQuery node synchronising from a non-zero height, all you have to do is to modify your project.yaml file and change the startBlock key.

Below is a project.yaml file where the start block has been set to 1,000,000

specVersion: 0.0.1
description: ""
repository: ""
schema: ./schema.graphql
  endpoint: wss://polkadot.api.onfinality.io/public-ws
  dictionary: https://api.subquery.network/sq/subquery/dictionary-polkadot
  - name: main
    kind: substrate/Runtime
    startBlock: 1000000
        - handler: handleBlock
          kind: substrate/BlockHandler

Why not start from zero?

The main reason is that it can reduce the time to synchronise the blockchain. This means that if you are only interested in transactions in the last 3 months, you can only synchronise the last 3 months worth meaning less waiting time and you can start your development faster.

What are the drawbacks of not starting from zero?

The most obvious drawback will be that you won’t be able to query for data on the blockchain for blocks that you don’t have.

How to figure out the current blockchain height?

If you are using the Polkadot network, you can visit https://polkascan.io/open in new window, select the network, and then view the "Finalised Block" figure.

Do I have to do a rebuild or a codegen?

No. Because you are modifying the project.yaml file, which is essentially a configuration file, you will not have to rebuild or regenerate the typescript code.

How to change the blockchain fetching batch size?

Video guide


The default batch size is 100, but this can be changed by using the extra command --batch-size=xx.

You need to this to the command line as an extra flag or if you are using Docker, modify the docker-compose.yml with:

    image: onfinality/subql-node:latest
      - "postgres"
    restart: always
      DB_USER: postgres
      DB_PASS: postgres
      DB_DATABASE: postgres
      DB_HOST: postgres
      DB_PORT: 5432
      - ./:/app
      - -f=/app
      - --local
      - --batch-size=50

This example sets the batch size to 50.

Why change the batch size?

Using a smaller batch size can reduce memory usage and not leave users hanging for large queries. In otherwords, your application can be more responsive. However, more API calls are being made so if you are being charged on an I/O basis or if you have API limits somewhere in your chain, this could work to your disadvantage.