Add database indices to the event store - Githubissues

ponder-sh / ponder

A backend framework for crypto apps

https://ponder.sh

MIT License

592 stars 86 forks source link

Add database indices to the event store #209

Closed 0xOlias closed 1 year ago

0xOlias commented 1 year ago

Ponder uses a SQL database to cache blocks, logs and transactions. We should add indices to speed our queries up (this is very low hanging fruit 😄).

Some thoughts:

There might be an automated way to determine which indices should exist.
All of the SQL queries are in this file.
Ponder uses Kysely as a query builder, which has helper methods for adding indices.
I'm guessing we can add these indices as a new migration in this file.
We'll need to do this for both SQLite and Postgres.
I'm guessing most of the indices we add will be related to the getLogEvents method/query.

0xOlias commented 1 year ago

Fixed in #226