#Question about query limits

2 messages · Page 1 of 1 (latest)

south widget
#

I just want to be sure, when I make a query and it scans and retrieves 10,000 documents:

Scan limit: 16,384 - 10,000
Db.query & db.get limit: 4096 - 1

And if I do 4,000 db.get operations:

Db.query & db.get limit: 4096 - 4000
Scan limit: 16,384 - ? How much is it?

Are these numbers correct?

dim echo
#

Scan limit: 16,384 - ? How much is it?
16,384 - 4000

db.get is an index lookup, it doesn't scan more than one document.

Otherwise you got it right.