Trivia App On Database

Database & APIs

Hello Fellow Developers !

I have made and trivia app

  • All the questions are inserted in "Questions" collection and i have another collection which is called "Games"

  • I Query Questions collection but filter it so that the question must have same "Game reference"

  • I have approximately 400 questions currently in my Questions collection but should I create own collection for each category ?

  • I tried my app played 10 games, 10 questions each so firebase reads should be approximately 200 ? Right ?

  • My reads are on almost 4K ?????

So the main question is that I should create own collection for each category in order to keep the reads low ?

In addition to this could someone clarify if i have a collection with 100 000 Documents but i filter the query so that only 10 will be used. Will my reads be at 100 000 or 10 ?

Thank you in advance !

What have you tried so far?

-

Did you check FlutterFlow's Documentation for this topic?
No
2
5 replies