launchbadge/sqlx

Add benchmarks to inform performance-oriented refactoring

Open

#158 opened on Mar 26, 2020

View on GitHub
 (0 comments) (1 reaction) (0 assignees)Rust (1,307 forks)batch import
enhancementhelp wanted

Repository metrics

Stars
 (13,916 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

Preferably these can run locally with a single script that uses docker to spin up/down database servers as needed to test all supported databases and versions.

I'm imagining a bench/ or perf/ folder that contains a run.sh script that does the "magic" but I'm pretty open here.

Update: We now have a docker-compose file that can spin up a database/version pair. This was one of the blockers here.

Contributor guide

Research direction
Create a benchmark suite using Rust's built in benchmarks or criterion. Use the existing docker compose to spin up database servers and measure connection pooling, query execution, and result handling. Reference the TechEmpower single query spec for the small query benchmark and design a large result set test with 10K rows and 5 columns including String and Vec<u8>.
Tech stack
rust
Domain
backenddatabase
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
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
RustDocker
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50