test-performance
/test-performance
Przyspiesza zestaw testów: konfigurację bazy danych, seedery, testy równoległe, wydajność pipeline'u CI i alternatywy dla RefreshDatabase.
- Autor
- event4u-app ↗
- Repozytorium
- agent-config ↗
- Licencja
- MIT
- Ostatnia zmiana repozytorium
- 26.10.2026
Ocena i bezpieczeństwo
- Pliki w paczce
- 2
- Skrypty
- 0
- Komentarze HTML
- 0
- Adresy URL w SKILL.md
- 0
Brak sygnałów. Repozytorium zmienione 26.10.2026, bez odwołań do wycofanych modeli i API.
MIT, otwarta: można używać i zmieniać, z zachowaniem informacji o autorze.
Co robi i kiedy
Przyspiesza zestaw testów: konfigurację bazy danych, seedery, testy równoległe, wydajność pipeline'u CI i alternatywy dla RefreshDatabase.
Oryginalny opis (EN)
Use when optimizing test suite performance — database setup, seeder optimization, parallel testing, CI pipeline efficiency, or RefreshDatabase alternatives.
Jak działa
- When to use
- Procedure: Analyze test performance
- Related project docs
- Output format
- Gotcha
- Do NOT
- Where the time goes, per ecosystem
Podgląd SKILL.md
---
model_tier: medium
name: test-performance
description: "Use when optimizing test suite performance — database setup, seeder optimization, parallel testing, CI pipeline efficiency, or RefreshDatabase alternatives."
domain: quality
framework: laravel
workspaces:
- engineering
packs:
- engineering-base
---
# test-performance
## When to use
Use this skill when:
- Tests are running too slowly (locally or in CI)
- Database setup/teardown is a bottleneck
- Parallel testing needs optimization
- Seeders need performance analysis
- CI pipeline test jobs need to be faster
- Investigating flaky tests caused by database state
## Procedure: Analyze test performance
### 1. Measure baseline
Before optimizing, always measure:
```bash
# Count tests per suite
find tests/ app/Modules/*/Tests/ -name "*.php" | xargs grep -l "it(" | wc -l
# Count by suite type
grep -rh "it(" tests/Unit/ app/Modules/*/Tests/Unit/ --include="*.php" | wc -l
grep -rh "it(" tests/Component/ app/Modules/*/Tests/Component/ --include="*.php" | wc -l
grep -rh "it(" tests/Integration/ app/Modules/*/Tests/Integration/ --include="*.php" | wc -l
# Count migrations
ls database/migrations/*.php | wc -l
# Count seeders
find database/seeders database/seeder-data -name "*.php" -path "*/data/*" | wc -l
```
### 2. Identify bottlenecks
The typical test lifecycle is:
```
Process Start → Migrate → Seed → [Test → Rollback] × N → Process End
↑ expensive (once per worker)
```
Check these areas in order of typical impact:
| Area | What to check | Typical impact |
|------|--------------|---------------|
| **Migration count** | How many CREATE TABLE statements? | High if >20 |
| **Schema dump** | Is `database/schema/` used? | High if missing |
| **Seeder INSERT method** | Individual `save()` vs bulk insert? | Medium |
| **Truncation** | Per-seeder truncate vs centralized? | Low (but causes correctness issues) |
| **Connection discovery** | Dynamic `getPdo()` probing? | Low |
| **Parallel worker setup** | Does each worker re-migrate? | High |
### 3. Optimization strategies (ordered by ROI)
#### A. Schema Dump (highest ROI)
Laravel's `schema:dump` consolidates all migrations into one SQL file.
Instead of running N individual CREATE TABLE migrations, it loads one SQL dump.
```bash
php artisan schema:dump --database=api_database
# Generates database/schema/api_database-schema.sql
```
**Savings:** 58 migrations → 1 SQL load = ~10-25s per worker.
#### B. Template DB Cloning (high ROI for parallel tests)
Instead of each parallel worker running migrate+seed independently:
1. Prepare ONE template database (migrate + seed)
2. Clone template for each worker via mysqldump
```bash
# Prepare template
php artisan migrate:fresh --database=template_db
php artisan db:seed --database=template_db
# Clone per worker
mysqldump template_db | mysql worker_db_test_1
```
**Savings:** Eliminate per-worker migrate+seed entirely.
#### C. Skip Migrate+Seed Flag (high ROI for local dev)
Add a config flag to skip database setup when DB is already prepared:
```php
// config/testing.php
'skip_migrate_seed' => EnvHelper::boolean('TESTING_SKIP_MIGRATE_SEED', false),
```
Developer workflow: `make migrate-testing` once, then `make test-quick` repeatedly.
#### D. Bulk Inserts in Seeders (medium ROI)
Replace individual `$model->save()` with bulk insert:
```php
// Before: N INSERT statements
foreach ($data as $row) {
$model = new MyModel($row);
$model->save();
}
// After: 1 INSERT statement
MyModel::insert($data);
$models = MyModel::whereIn('id', $ids)->get();
```
#### E. Centralize Truncation (correctness fix)
Per-seeder truncation is redundant after `migrate:fresh` and causes:
- Non-deterministic ordering (lazy init triggers truncate)
- Ghost data bugs (locally passes, CI fails)
Make truncation configurable, default off:
```php
// config/testing.php
'seed_truncate' => EnvHelper::boolean('DB_SEED_TRUNCATE', false),
```
#### F. Static Connection Discovery (cleanup)
Replace dynamic `getPdo()` probing with explicit config:
```php
// config/testing.php
'connections_to_transact' => ['api_database', 'customer_database'],
```
### 4. CI-specific optimizations
- **MariaDB tmpfs:** Mount data dir on RAM disk for zero I/O latency
- **Shared DB prep:** One CI job prepares DB, test jobs clone from it
- **Cache test DBs:** Skip re-migration if migration files haven't changed
- **Separate suites:** Run no-DB tests (Unit) on cheaper runners
## Related project docs
- `agents/reference/docs/seeders.md` — seeder conventions (if exists)
## Output format
1. Optimized test configuration or seeder with timing comparison
2. Parallelization or caching improvements applied
## Gotcha
- Don't use RefreshDatabase when DatabaseTransactions suffices — full refresh is 10x slower.
- The model forgets that parallel tests share the database — use unique identifiers in test data.
- Seeder optimization has the highest ROI — a 2s seeder running 100 times = 200s wasted.
- Don't add indexes to test databases just for test performance — the real fix is better test design.
## Do NOT
- Do NOT use RefreshDatabase when DatabaseTransactions works — 10x slower.
- Do NOT run full test suite on every code change — use `--filter`.
- Do NOT add test-only indexes — fix test design instead.
- Do NOT disable parallel testing to "fix" flaky tests — fix the root cause.
## Where the time goes, per ecosystem
The diagnosis above is PHPUnit-shaped. The method — measure before optimising,
find the slowest tests first, separate setup cost from assertion cost —
transfers; the instrument does not. Resolve the runner with
`resolve_toolchain` and read its `ecosystems`:
| `ecosystems` | Slowest-test instrument | The usual first cause |
|---|---|---|
| `php` | `--profile` / Pest's duration column | database refresh per test |
| `js` | `vitest --reporter=verbose`, `jest --detectOpenHandles` | module transform and a leaked handle |
| `python` | `pytest --durations=20` | session-scoped fixtures rebuilt per test |
| `go` | `go test -v`, `-cpuprofile`, `-race` for the slow-and-flaky pair | a `TestMain` that starts real I/O |
`go test` caches a package's result until its inputs change, so a suite that
looks fast on the second run may not have run at all — `-count=1` defeats the
cache when you are measuring.
Pliki w paczce (2)
- SKILL.md 6 KB
- evals/triggers.json 3 KB
Wersje
W bazie nie ma innych skilli o nazwie test-performance.
Migawka bazy z 13.11.2026 · wersja paczki 0841a2093e2d (skrót SHA-256 całej paczki)
Pobrania w ostatnich 30 dniach: 0 · ranking
Zgłoś problem z tym skillem: szkodliwa treść, błędny opis albo prośba autora o usunięcie.
Podobne skille
- 100laravel-testing
Pisze testy funkcjonalne Pest w Laravel z RefreshDatabase, mockami usług zewnętrznych i danymi testowymi z fabryk Eloquent, w tym bazę SQLite w pamięci. - 100qe-performance-testing
Testuje wydajność, skalowalność i odporność aplikacji, w tym testy obciążeniowe i stresowe oraz optymalizację wydajności systemu. - 100gds-performance-test
Projektuje strategię testów wydajności i benchmarków dla gry oraz plan ich wykonania. - 100seed-test-data
Tworzy idempotentne seedery danych testowych QC (happy path) przez publiczne komendy, a w trybie review tylko do odczytu audytuje konwencje seederów. - 100seed-test-data
Tworzy idempotentne seedery danych testowych QC (happy path) przez publiczne komendy, a w trybie review tylko do odczytu audytuje konwencje seederów. - 100spike-test-setup
Prawdopodobnie konfiguruje testy skokowe obciążenia (spike test) w ramach testów wydajności.