[CLOUD_FIRESTORE] Long fetching time of data in local cache

[LiLatee]

[REQUIRED] Step 2: Describe your environment

Packages in Flutter project:

• firebase_core: 4.4.0
• cloud_firestore: 6.1.2 (corresponding to Firebase BoM 34.7.0)

[REQUIRED] Step 3: Describe the problem

We've noticed an issue with persistent storage in our Flutter project. Very similar to #7198 (comment). It happens only on Android, I’m not able to reproduce it on iOS.
When we have a lot of cached data e.g. 5k records, then some specific queries need much more time to be executed e.g. 100ms vs 2s.

Here is an example of a query:

    final DateTime nowDateTime = DateTime.now();
    query = query
        .where('Dateandtime', isGreaterThanOrEqualTo: Timestamp.fromDate(nowDateTime))
        .where('Dateandtime',
            isLessThanOrEqualTo: Timestamp.fromDate(nowDateTime.add(const Duration(days: 7))));

Disabling persistence storage fixes the issue.
I also tried enabling automatic index creation and manually providing indexes, but I didn’t notice any significant difference.

Steps to reproduce:

1. Fetch a list of items using Stream. It should return data very quickly.
2. Persistence storage is enabled. Fetch ~5k random items.
3. Execute the same query as in step 1. The execution time increases a lot.

Here is also a SQLite database with the state at which executing the above query takes ~2s instead of 200ms.
https://drive.google.com/file/d/1rP3hB6qSMjRqUshvmS7rMrNIhDJSXyqh/view?usp=sharing

cc: @dconeybe
If you won't be able to reproduce the issue let me know. I will try to help.

[yethunaingiso077-rgb]

ThankYou

…

On Sun, Mar 15, 2026, 8:44 PM Marcin Hradowicz ***@***.***> wrote: *LiLatee* created an issue (firebase/firebase-android-sdk#7914) <#7914> [REQUIRED] Step 2: Describe your environment Packages in Flutter project: - firebase_core: 4.4.0 - cloud_firestore: 6.1.2 (corresponding to Firebase BoM 34.7.0) [REQUIRED] Step 3: Describe the problem We've noticed an issue with persistent storage in our Flutter project. Very similar to #7198 (comment) <#7198 (comment)>. It happens only on Android, I’m not able to reproduce it on iOS. When we have a lot of cached data e.g. 5k records, then some specific queries need much more time to be executed e.g. 100ms vs 2s. Here is an example of a query: final DateTime nowDateTime = DateTime.now(); query = query .where('Dateandtime', isGreaterThanOrEqualTo: Timestamp.fromDate(nowDateTime)) .where('Dateandtime', isLessThanOrEqualTo: Timestamp.fromDate(nowDateTime.add(const Duration(days: 7)))); Disabling persistence storage fixes the issue. I also tried enabling automatic index creation and manually providing indexes, but I didn’t notice any significant difference. Steps to reproduce: 1. Fetch a list of items using Stream. It should return data very quickly. 2. Persistence storage is enabled. Fetch ~5k random items. 3. Execute the same query as in step 1. The execution time increases a lot. Here is also a SQLite database with the state at which executing the above query takes ~2s instead of 200ms. https://drive.google.com/file/d/1rP3hB6qSMjRqUshvmS7rMrNIhDJSXyqh/view?usp=sharing cc: @dconeybe <https://github.com/dconeybe> — Reply to this email directly, view it on GitHub <#7914>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/B5VWI5VKL2WMN6543SARCID4Q2XSDAVCNFSM6AAAAACWSPMTG2VHI2DSMVQWIX3LMV43ASLTON2WKOZUGA3TQNBQGIZDCNA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[dconeybe]

Thanks for this information! I'll see if I can reproduce.

[wu-hui]

This comment might help: #7905 (comment)