0

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.

Artur Sponchiado
  • 3
  • 1
  • 2

1 Answers1

0

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.

Frank van Puffelen
  • 565,676
  • 79
  • 828
  • 807
  • Thanks Frank! So if I have a collection with high rate writes, maybe is it better to move that collection to a subcollection? – Artur Sponchiado Mar 23 '19 at 20:00
  • To a single subcollection won't make a difference. But sharding the same documents over multiple subcollections indeed will likely increase write throughput. – Frank van Puffelen Mar 23 '19 at 20:39