Skip to main content

​
Overview

As a quick test of Mirror’s write performance, we ran a pipeline of each size backfilling Ethereum blocks data (~18.5M rows as of October 23, 2023) with an unmodified schema. This test was performed on a 720 GiB RAM, 180 vCPU ClickHouse Cloud instance to ensure that non-pipeline factors (eg. disk IO, available memory, CPU cores) do not act as a bottleneck. Each test was run on a completely clean instance (ie. no existing tables) with no other queries or commands running on the database.

​
Results

Related topics

Use declared eth_calls to increase indexing performanceHealth dashboardTurbo SQL Functions ReferenceBlackholeSubgraphs vs. pipelines