Add benchmarks to inform performance-oriented refactoring · launchbadge/sqlx#158

(0 留言) (1 反應) (0 負責人)Rust (13,916 star) (1,307 fork)batch import

enhancementhelp wanted

描述

Establish a new connection.
Checkout an existing ( and idle ) connection from the pool.
Ping a connection.
Small query, small results ( following the specs over at tech empower: https://github.com/TechEmpower/FrameworkBenchmarks/wiki/Project-Information-Framework-Tests-Overview#single-database-query ). Do nothing with the results.
Small query, huge results ( 10K rows with at least 5 columns where 2 of the columns are String and Vec<u8> ). Do nothing with the results.

~~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.

貢獻者指南

技術棧: rustpostgresqlmysqlsqlite
領域: backenddatabaseperformance
議題類型: feature
難度: 3
預計時間: 1-2 days
活動狀態: stale
清晰度: clear
前置要求: Rust knowledgesqlx basic usageDocker basics
新手友善度: 60
研究方向: Review the existing sqlx repository structure to understand how database connections are handled. Use the docker compose file mentioned in the issue to spin up database servers for PostgreSQL, MySQL, and SQLite. Then create a `bench/` folder with a `run.sh` script that executes benchmarks for each scenario listed in the issue: establishing a connection, checking out and pooling idle connections, pinging a connection, a single small query, and a small query with large results. The benchmarks should be written in Rust using a benchmarking crate like `criterion`.