You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a collection that hosts documents with some fields and a big nested map of smaller items.
doc =
field1:value
field2:value
field3:value
field4:map {map_item:{field id, field b, field c, ...}
When querying this construct with a simple "where field1 == valueX, I get insanely slow query responses.
For 20 document with about 500 map_items query time is upwards of 10secs. would anyone know why this is?
There is 18 docs with a total of 4700 map_items, somewhat unevenly distributed. Some have 30, one has about 1000...
--------> Executing firestore query took 12103 milliseconds to execute
--------> Found 18 annotation documents
--------> Found 4707 annotations
I am on a 1GB fiber connection and the geo-location is on the same continent. I can pull down 500mb of python libraries faster than these 18 docs from a single collection.
Attached an image of what each map_item looks like.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Dear all,
I have a collection that hosts documents with some fields and a big nested map of smaller items.
doc =
field1:value
field2:value
field3:value
field4:map {map_item:{field id, field b, field c, ...}
When querying this construct with a simple "where field1 == valueX, I get insanely slow query responses.
For 20 document with about 500 map_items query time is upwards of 10secs. would anyone know why this is?
Kind regards,
Kai
Beta Was this translation helpful? Give feedback.
All reactions