Firebase linear nodes

Question

I am starting to use Firebase to store data information. I learned that it is better to have it in a narrow structure instead of deep structure.

I have the following structure:

MainDetail
  -Kd92jd93kaod93  <----ID
  -Kfirkd9rmtiepr
  -.....More than 1 million more

The question I have is that, I have over a million data and over a million ID's will be stored in a linear sequence under each main nodes like above.

Is this a good approach to have all the ids in one nodes? or should I break it down further such as by a date? Like...

01_MainDetail
  -20170902
      -Kd92jd93kaod93 
      -Kfirkd9rmtiepr
      -....
  -20170901
      -Kd92jd93rt4e3 
      -Kfer5hrmtiepr
      -....      
  -....

This contradicts what I read online as now I am not making it narrow and having multiple children.

What is the right approach when I have lots of data?

score 1 · Answer 1 · answered Sep 03 '17 at 05:55

1

The Good approach is to keep data organised like you said in chunks of dates under parent node.

This approach will not be a source of trouble for you.

answered Sep 03 '17 at 05:55

Muhammad Zubair Saleem

507
6
23

score 1 · Accepted Answer · answered Sep 03 '17 at 13:11

There is no realistic limit on the number of child nodes under a node. It all depends on how you want to access those child nodes. Specifically:

Querying long lists of data will always take more time than querying a shorter list of data.
Reading a list of nodes will always be faster that querying for those same nodes from a longer list.

See these answers for more:

It is often best to partition data to match with how you want to access it. The second data structure you show is an example of that, since it allows you to access the nodes for a specific date without needing to query for them.

Firebase linear nodes

2 Answers2