How can I add pagination or infinite scroll to dynamic children (Firestore query)

Database & APIs

I'm doing a query to my Firestore database at the page level. Then I'm generating dynamic children in two separate ListViews, so that I can implement a simple search (the way that Flutterflow recommends in their own tutorial). But when I start importing real production data, the search results return 300 or more items, and the app just spins forever.

Clearly it's stalling out. So I need to be able to paginate or add infinite scroll.

What have you tried so far?

From Flutterflow's documentation, it seems like it's relatively straightforward to add infinite scroll to a ListView when the query is happening on the ListView itself (i.e. not as dynamic children). But when I try to add infinite scroll to the query that's happening at the page level, the option isn't there. Similarly, when I try to add it on the dynamic children, the option isn't there.

I'm open to any solution that will get the app working and not stalling on the first screen. Pagination would also be fine, but I don't see a way to paginate data from Firestore.

Help!

Did you check FlutterFlow's Documentation for this topic?
Yes
2