CODEWITHSUNDEEP
firebasegoogle-cloud-firestore
Artur Sponchiado
Artur Sponchiado

Reputation: 3

Does single-field index limitation applies to compound indexes too?

I'm using Firebase Cloud Firestore for my project and stumbled in this limitation:

Maximum write rate to a collection in which documents contain sequential values in an indexed field: 500 per second

I understand the limitation based on this answer. But if I disabled auto single-field indexes in firebase console, and only use this fields in compound indexes, this limitation still continues? I mean, does this single-field index limitation extends to compound indexes?

Thanks.

Upvotes: 0

Views: 56

Answers (1)

Frank van Puffelen
Frank van Puffelen

Reputation: 599706

The limitation applies to writes to collections that have indexes. It applies equally to single-field and to compound indexes.

It's easiest to think of this as writing to a set of files, where you can write to each file about 500 times per second. Entries in an index that are close to each other (e.g. sequential) are written to the same 'file', so you can only write about 500 items close to each other in any index per second.

Upvotes: 0

Related Questions