Why is my Firestore query slow? #AskFirebase

Welcome to another episode of #AskFirebase! Today, both of our co-hosts David East and Sumit Chandel team up to answer all your burning Firebase questions! Watch to find out the answers like…

0:47 - I have a SQL server. I want to develop a Flutter app with the Firestore. Is there a way to implement interacting with this data from the by Firestore?
2:27 - Can I use multiple Cloud Firestore databases in a single app?
4:02 - Why is my Firestore query slow?
7:26 - Why is the data from a Firestore document snapshot returned with a .data() function rather than a .data property, since the complete document data was already fetched with the snapshot?

Remember to use #AskFirebase to get your question answered!

Links:

[nicolapigozzo]

#AskFirebase when will group queries finally supported by firestore? Do we still have to use Algolia for this?

[raghav]

Couldn't find credible open source examples of Firestore + SQL Combo..any links that you can share would be super helpful..

[adityaghone]

I am trying to import collection of db of 6gb but it gives 30000ms timeout error for my localhost

[FernandoGVilar]

#AskFirebase:


I have a couple of questions about Firestore field indexing


I am trying to prevent some fields in my Firestore docs from automatically indexing. I know I can setup 200 single field exemptions but I am asking if there is another way. In the past, I have worked with the Datastore (which I believe must be a close relative of Firestore), and what I used to do was use Go's struct tags to mark a field as "noindex".


1) Is there a way I can achieve this with Firestore both in a Go cloud function or in the web javascript client?


or


2) how can I prevent a field from being indexed across all collections? No matter what the collection name is. What happens if I use an asterisk (or some other wildcard) as the collection name? Will that do the trick?


thanks!

[jordanmunroe]

I have one collection with 1 document in it. I am getting a this single document by its id and it takes 115 seconds. What the heck? This is broken. I cannot use this.

[harshptl]

Can I make location wise database with Firebase for my flutter application?

[techplanet]

Wow how do i usw the multiple database was my surprise

[samuelmarndi]

#Askfirebase Is there a plan to bring sql database to firebase or firebase is exclusively going to use only NoSQL

[guillaumeblaquiere]

Slow query can't be due to hot spot because of too similar document id? Consecutive values in a sequence for example

[KHAGAPATIMAHANTA]

#AskFirebase
How to make a rule in firebase auth delete user for client app ?

[kld]

wheres fire girl? what happened to her?

[kayzweller_dj]

But can two different apk access the same database, cuz I wanna make admin and the user apk in different packages 😁 thanks you~

[FamilyGuyVids]

#AskFirebase My question: Say I have a website that lets users vote on content (use reddit as an example). I would be updating post.voteCount++ but the Firebase docs say "You should not update a single document more than once per second." How do you handle that? There may be times where a certain post gets a lot of votes within a 1 second period. What are the dangers and how should we design our requests/cloud functions to deal with fast moving documents.

[kayzweller_dj]

Integration with the SQL database seem promisingly good, any example how that's work?

[PlayerHeader]

I don't understand the fun fact, from which country is he

[rishabhanand]

Great series, but please remove the cringe stuff (no offense though). Or get surma and archibald?!!