61 replies

Limit on number of documents read in a query

Hi friends! We were doing some pretty innocent queries and we hit a 16384 documents in a query limit....

I created a standalone repro for your convenience.
https://github.com/vors/convex-load-test

Please help us understand is that a fundamental limitation of the platform or am I just stupid with how I write my queries. The meat is that we do this

await db
    .query("messages")
    .filter((q) => q.eq(q.field("_id"), id))
    .collect();

await db
    .query("messages")
    .filter((q) => q.eq(q.field("_id"), id))
    .collect();

Which is obviously stupid way of doing

db.get

db.get

but it will do for the illustration pusposes I think. Imagine that it's some other, non-id field. UPD: non-id field with a index on it.

Convex Community•3y ago•

61 replies

vors

Limit on number of documents read in a query

await db
    .query("messages")
    .filter((q) => q.eq(q.field("_id"), id))
    .collect();

await db
    .query("messages")
    .filter((q) => q.eq(q.field("_id"), id))
    .collect();

Which is obviously stupid way of doing

db.get

db.get

but it will do for the illustration pusposes I think. Imagine that it's some other, non-id field. UPD: non-id field with a index on it.

Limit on number of documents read in a query

Similar Threads

Limit on number of documents read in a query

Similar Threads

Similar Threads

Similar Threads