Using custom query with typescript filtering and pagination. Performance and limitation issues.
Hello together,
I have a question regarding quering with streams and
I set the index "title" but there are problems which I need to figure out and would like to ask you.
First, Convex blocks if the size of report table is bigger then 16MB
Second, the performance.
I was thinking that there most be a way that filterings needs to be performed in batches so that the search and looping is stopped until the pagination limiting is finished.
What would be the correct convex way to solve this problem?
Thank you
I have a question regarding quering with streams and
.filterWith.filterWith. We have this table structure
We want to perform a search by
We want to perform a search by title and and content` query, which does a include filtering based on JavaScript. We use this mutation:I set the index "title" but there are problems which I need to figure out and would like to ask you.
First, Convex blocks if the size of report table is bigger then 16MB
Second, the performance.
I was thinking that there most be a way that filterings needs to be performed in batches so that the search and looping is stopped until the pagination limiting is finished.
What would be the correct convex way to solve this problem?
Thank you
