Count the Items in a Collection with a Custom Data Loader

Jacob Paris
InstructorJacob Paris
Share this video with your friends

Social Share Links

Send Tweet
Published 3 years ago
Updated 3 years ago

If users will be often querying the number of comments without also querying the list of comments

Then fetching the entire comment collection is wasteful. It's also not compatible with any pagination features that don't return the entire collection.

In this lesson, we will create a custom Data Loader specifically for counting items

Instructor: [0:00] If users will often be querying the number of comments without also querying the list of comments, then fetching the entire comment table is wasteful. It's also not compatible with any pagination we might add later since we still need the total count.

[0:14] We can give it a dedicated comment count by post idLoader that selects post ID, counts post ID, groups by post ID, where a post ID is in keys, then maps each key to the count for that post ID, or zero if there were none. Update the resolver to use the new loader.

[0:47] You can run the query again, but it will show the same output as before.

egghead
egghead
~ 19 minutes ago

Member comments are a way for members to communicate, interact, and ask questions about a lesson.

The instructor or someone from the community might respond to your question Here are a few basic guidelines to commenting on egghead.io

Be on-Topic

Comments are for discussing a lesson. If you're having a general issue with the website functionality, please contact us at support@egghead.io.

Avoid meta-discussion

  • This was great!
  • This was horrible!
  • I didn't like this because it didn't match my skill level.
  • +1 It will likely be deleted as spam.

Code Problems?

Should be accompanied by code! Codesandbox or Stackblitz provide a way to share code and discuss it in context

Details and Context

Vague question? Vague answer. Any details and context you can provide will lure more interesting answers!

Markdown supported.
Become a member to join the discussionEnroll Today