nextcloud / nextcloud/cookbook
Enhance handling of keywords during readout
Nobody has claimed this yet.
- Dominant language
- HTML
- Stars
- 641
- Forks
- 113
- Avg merge
- 21h 31m
- Merged PRs (30d)
- 26
Description
Is your feature request related to a problem? Please describe.
Currently, to fetch the keywords of a recipe, one set of SQL queryies are generated (see here).
At least for the categories there is a 1:1 relation that could be realized using a join statement. This should be optimized eventually.
The keywords could be fetched on one big database query and assigned to the recipe entries in RAM.
Contributor guide
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 in lib/Service/DbCacheService.php around lines 190-195, where the current keyword queries are generated. Read how recipe entries and categories are represented, then determine how the requested database query and in-memory assignment should fit that flow. Done means keyword data is fetched with the intended optimized query while preserving recipe results.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php, sql
- Domain
- backend, databases
- Issue type
- Refactor
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 38/100