Test-More / Test-More/Test2-Harness
Additional Indexes for Database Query Performance
Open
Nobody has claimed this yet.
- Dominant language
- Perl
- Stars
- 28
- Forks
- 30
- PR merge metrics
- No merged PRs in 30d
Description
Adding indexes on reporting and run_fields is likely to improve the performance of queries on the YathUI database, especially those looking back on data for a large number of runs in a window.
Specifically,
CREATE INDEX reporting_run_analytics
ON reporting (run_id, test_file_id, subtest, pass, fail, duration);
CREATE INDEX run_fields_name ON run_fields (name);
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the schema or migration entry points for the reporting and run_fields tables, then inspect how YathUI queries them over large run windows. Add the two indexes shown in the issue and verify that the indexes exist and improve the relevant query performance without breaking database setup.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, performance
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 68/100