Check this link to know all the limits for the Firebase database:
https://firebase.google.com/docs/database/usage/limits
But according to the link it says, that you can have 75 million nodes.
Total nodes in a path with listeners or queries on it is 75 million*
You can't listen to or query paths with more than 75 million nodes, cumulative. However, you can still listen to or query child nodes. Try drilling down deeper into the path or creating separate listeners or queries for more specific portions of the path.
*You can't view paths with more than 30,000 total nodes from the data viewer in the Firebase console.
Regarding "time"(how much it will take for users to access data), it all depends on how you do your queries. Example instead of looping in the whole node to get the data, you can just specify the user so you do not need to loop.
Another example is to use addListenerForSingleValueEvent
instead of ValueEventListener
as it reads data once.
Example retrieving data of a user, can do this:
DatabaseReference ref = FirebaseDatabase.getInstance().getReference("Student");
String uid = FirebaseAuthentication.getInstance().getCurrentUser().getUid();
ref.child(uid).addListenerForSingleValueEvent(new ValueEventListener() {
@Override
public void onDataChange(DataSnapshot dataSnapshot) {
String name=dataSnapshot.child("name").getValue().toString();
}
@Override
public void onCancelled(FirebaseError firebaseError) {
}
});