Joystream / Joystream/joystream

Speed-up Pioneer category lists

Open
#2,599 3 comments 0 reactions 1 assignee View on GitHub

@thesan is already working on this.

Since Jan 28, 2022.

estimate-12h forum-pallet query-node scope:pioneer-support
Dominant language
Rust
Stars
1.4k
Forks
116
No merged PRs in 30d

Description

Pioneer forum category pages (e.g: here) are sending a way to many queries, because each category "LAST POST", "POPULAR" and "TOTAL THREAD" as well as each thread "LAST ACTIVITY" are queried separately. Which amount to: 3 x number of subcategories + 1 * number of thread individual queries.

Instead:

  • ForumCategory should have a visibleThreadCount field similarly to ForumThread.
  • ForumCategory should have a popularThread field.
  • Both ForumThread and ForumCategory should have a latestPost field.

This should significantly reduce the load of Pioneer's forum category pages on the query node

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.