When I use a paginated query, is there a quick way to know the total count?
I am querying a large dataset, and I have filters based on many fields, some of them are user generated.
This means that there is no way to cache the filter result, because there could be an infinite amount of combinations.
Right now I need to use and count all the documents.
Is there a more efficient way of doing this?
(My database bandwidth is growing too fast)
2 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
Use the aggregate component: https://www.convex.dev/components/aggregate#total-count-and-randomization