ecgan / firestore-considerations Goto Github PK

It might be worth documenting the limitations on queries such as no != comparisons, etc

Hi there, I'm building an app that will probably deal with hundreds of thousands of entries. I have to save each sale entry inside my dabatase, which Firestore or RTDB were introduced to me as alternatives.

The idea is the following:

• Each user can create an event

• All sales entry in an event must be saved

Based on this I thought that creating one big document with all sales data in each event would be better since the events sales I’m aiming for deals with something around 2k ~40k entries per event. When I tried to create a list of documents for each sale entry the approach used all my plan data usage.
What would you think would be a good approach?

Firestore can now perform collection group queries.
https://firebase.google.com/docs/firestore/query-data/queries#collection-group-query