How to do an array contains query over a large table?
Hi,
I have a table with over 100k docs and I have a field (
What is the best way to find the documents in this table, such that the corresponding array at
It looks like convex doesn't support an arrayContains filter, and I can see the suggestion to read the full table into memory and then filter this using js...?
But I think with a large table like this then this won't work because I will either hit the (~16k) document scan limit, or run out of memory?
I have a table with over 100k docs and I have a field (
fieldA) on the table, values of which are arrays of strings.What is the best way to find the documents in this table, such that the corresponding array at
fieldA contains a certain string?It looks like convex doesn't support an arrayContains filter, and I can see the suggestion to read the full table into memory and then filter this using js...?
But I think with a large table like this then this won't work because I will either hit the (~16k) document scan limit, or run out of memory?
