If you have any more queries, feel free to hop on our discord channel.

If you have any more queries, feel free to hop on our discord channel.

https://discord.gg/graphprotocol

These 2 tips are very small changes, but they will greatly impact the subgraph's indexing and querying performance.

Do check the detailed blog by David Lutterkort

These 2 tips are very small changes, but they will greatly impact the subgraph's indexing and querying performance.

Do check the detailed blog by David Lutterkort

https://thegraph.com/blog/two-simple-subgraph-performance-improvements/

This performance measurement was done in a controlled environment where 4 subgraphs were deployed.

base - immutable ❌ & bytes ❌
immutable - immutable ✅ & bytes ❌
bytes - immutable ❌ & bytes ✅
both - immutable ✅ & bytes ✅

2. Use type Bytes for id in entities rather than type ID

How does it make a difference?
In simple words, type ID takes twice the space of Bytes and comparison of strings in Bytes is much cheaper than in type ID.

How does it make a difference?

When entity types are marked as immutable, 
graph-node uses database indexes that are much cheaper to build and maintain than mutable entities.

1. Mark entities as immutable whenever possible If you will not edit the entity in the future.

In schema.graphql, you can mark entities as immutable as given below.

The Graph is a web3 protocol for organizing and accessing blockchain data 🧑‍🚀 Official account of The Graph ecosystem 🌐
thegraph.com

Are you building subgraphs on @graphprotocol?   

Here are 2 simple tips to boost your subgraph's indexing and querying performance 🔥

A small thread 🧵

Have you experimented with @farcaster /frames? I can highly recommend it. So much fun 🤓. 

The Graph recently hosted a bounty for hackers building inventive new Frames powered by subgraphs. I’m blown away by the quality of submissions 🤩

Check out the winners and their frames below ⬇️

Here are the winners: https://warpcast.com/schmidsi/0x142f1b5a

Congrats to @3070 @hashir @shiyasmohd and @limone.eth

your friendly neighborhood lemon 🍋 squeezing onchain | serial hacker w/ builders.garden | bringing italy onchain @urbe-eth & /ethrome 🐺

https://limone.lol

Catania, Metropolitan city of Catania, Italy

surfacing voices, using tools, deleting data, /xxxx ing

Developer Relations at Edge & Node, working on The Graph. Opinions are mine.

Here are the winners: https://warpcast.com/schmidsi/0x142f1b5a

Congrats to @3070.eth @hashir @shiyasmohd and @limone.eth

Ever wondered what your Ethereum footprint looks like?🧐

Unlock the secrets of your Ethereum adventures at ETHWrapped!🚀 Discover your on-chain activity now!!!

Input your ENS / Lens handle / EVM Address and wrap your version ✨

Ever wondered what your Ethereum footprint looks like?🧐

Unlock the secrets of your Ethereum adventures at ETHWrapped!🚀 Discover your on-chain activity now!!!

Input your ENS / Lens handle / EVM Address and wrap your version ✨

https://frames.ethwrapped.xyz

Ever wondered what your Ethereum footprint looks like?🧐
Unlock the secrets of your Ethereum adventures at ETHWrapped! 🚀 Discover your on-chain activity now!!!

Input your ENS / Lens handle / EVM Address and wrap your version.

Ever wondered what your Ethereum footprint looks like?🧐
Unlock the secrets of your Ethereum adventures at ETHWrapped! 🚀 Discover your on-chain activity now!!!

Input your ENS / Lens handle / EVM Address and wrap your version.
https://frames.ethwrapped.xyz/