Understand query performance using Query Explain → https://goo.gle/4dZSxxj
In the final part of our Firestore Enterprise series, we’re putting everything together to build a deep intuition for query performance. We’ve learned that the Enterprise edition is powerful, but with great power comes the responsibility of optimizing for your application's particular query needs. Morgan Chen, a Developer Relations Engineer, breaks down exactly when Firestore is fast or slow and explains why using underlying database constraints. If you want to avoid high latency and unexpected billing, understanding the balance between index scans and collection scans is essential.
More resources:
Episode 1 in the series → https://goo.gle/4uoi5sE
Episode 2 n the series → https://goo.gle/4v1ngjC
Chapters:
0:00 - Recap: Standard vs. Enterprise performance
1:16 - Example 1: Core Operations in a pipeline
1:51 - Example 2: Filtering on two separate field
2:37 - Example 3: Sorting on a field value after applying a transformation to it
3:04 - Example 4: Both an indexed and unindexed recipes collection will have linear time performance
3:22 - Index speedups for aggregates (count, sum, avg)
3:35 - Example 5: No index speedup for regex comparison
4:01 - Tools: Google Cloud Console: Firebase Query Explainer
4:26 - The math: Complexity & time guarantees
5:47 - Revisiting a query from the previous video in the series
6:33 - Potential new features
#Firebase
Watch more Firebase Fundamentals → https://goo.gle/Firebase-Fundamentals
Subscribe to Firebase → https://goo.gle/Firebase
Speaker: Raphael Couto (xWF)
Products Mentioned: Firebase