firebase / firebase/firebase-admin-node

[Firestore] Very slow GET requests

Open
#2,932 6 comments 0 reactions 1 assignee Claimed by @ehsannas View on GitHub
api: firestore
Dominant language
TypeScript
Stars
1.7k
Forks
419
Avg merge
3d 10h
Merged PRs (30d)
16

Description

### [REQUIRED] Step 2: Describe your environment

* Operating System version: Linux
* Firebase SDK version: 13.4.0
* Firebase Product: Firestore
* Node.js version: 22
* NPM version: 10.9.2

### [REQUIRED] Step 3: Describe the problem
We have simple Firestore queries, filtering on simple properties.
When fetching from backend (nodejs), it takes a very very long time.
Same query using frontend libraries takes 1% of the time.

Explain query shows that the backend query is fast, but the result takes forever to download.

If we use Firebase frontend client libraries, the same query result is loaded 50x faster.

As an example, a query with result set of 100 documents took 4 seconds to fetch with firebase-admin
1000 documents took 21 seconds to fetch with firebase-admin

This is not a network issue, as we can run the same queries on backend and frontend from same hardware, and get 50x faster results in the client libary, compared to firebase-admin.

Any idea what it could be?

It is NOT the query that is the issue, using tools we can see that correct index is used.
We can also see that result set is streamed right away.

But the actual fetching of result data takes forever with this library.

Thanks in advance

Here is a snippet from a query with result set of 1000. We can see that result is immediately starting to download.

```
Firestore (7.11.0) 2025-06-09T14:36:33.255Z CNebO [ClientPool.acquire]: Creating a new client (requiresGrpc: false)
Firestore (7.11.0) 2025-06-09T14:36:33.310Z ##### [clientFactory]: Initialized Firestore GAPIC Client (useFallback: rest)
Firestore (7.11.0) 2025-06-09T14:36:33.311Z CNebO [Firestore.requestStream]: Sending request: {"parent":"projects/fastorder-prod/databases/(default)/documents/company/gorilla","structuredQuery":{"from":[{"collectionId":"orders"}],"where":{"fieldFilter":{"field":{"fieldPath":"orderStatus"},"op":"NOT_EQUAL","value":{"stringValue":"ARCHIVED"}}},"limit":{"value":2}}}
Firestore (7.11.0) 2025-06-09T14:36:34.856Z CNebO [Firestore.requestStream]: Received response: {"document":{"fiel.... rest of result set

```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.