stacks-network/stacks-core

[Chore] Benchmark sqlite performance

Open

#4,694 opened on Apr 18, 2024

View on GitHub
 (3 comments) (0 reactions) (0 assignees)Rust (758 forks)auto 404
benchmarkinggood first issueicebox

Repository metrics

Stars
 (3,063 stars)
PR merge metrics
 (PR metrics pending)

Description

Came across an interesting benchmarking tool and service

https://bencher.dev/ https://bencher.dev/learn/engineering/sqlite-performance-tuning/

Thought it would be an interesting exercise to compare our queries against an sqlite benchmark tool like this to see if there any improvements in how we do things.

Contributor guide

Research direction
Use the bencher.dev tool to benchmark SQLite queries in the stacks core project and identify performance improvements.
Tech stack
rustsql
Domain
backenddatabaseperformance
Issue type
Chore
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
Rust
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60