Remove the need for additional queries in template variables resolution #5319
Assignees
Labels
Comments
8 tasks
snejus
added a commit
that referenced
this issue
Jun 17, 2024
Another and (hopefully) final attempt to improve querying speed. Fixes #4360 Fixes #3515 and possibly more issues to do with slow queries. This PR supersedes #4746. ## What's been done The `album` and `item` tables are joined, and corresponding data from `item_attributes` and `album_attributes` is merged and made available for filtering. This enables to achieve the following: - [x] Faster album path queries, `beet list -a path::some/path` - [x] Faster flexible attributes queries, both albums and tracks, `beet list play_count:10` - [x] (New) Ability to filter albums with track-level (and vice-versa) **db** field queries, `beet list -a title:something` - [x] (New) Ability to filter tracks with album-level **flexible** field queries, `beet list artpath:cover` - [x] (New) Ability to filter albums with track-level **flexible** field queries, `beet list -a art_source:something` ## Benchmarks  You can see that now querying speed is more or less constant regardless of the query, and the speed is mostly influenced by how many results need to be printed out  Compare this with what we had previously  ## Later #5318 #5319
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Once #5240 is merged, adjust the templates resolution logic using the new design to remove additional SQL queries.
The text was updated successfully, but these errors were encountered: