I have a query suppose I have 1 million users in my database (SQL) and I establish a connection to firebase using the firebaseid for each user and I have 6 domains in my firebase db for which I want to get the initialScore for each domain which is present inside the name of the domain node i.e. Suppose the domain name is "Sleep" and inside the node named "Sleep" I have the initialScore as 7 and there are altogether 6 domains and I need to get the initialScore for each of them for my report so, for each user i will have to fetch the body of each domain which makes a total of 1 million * 6 iterations for each user, so how do i optimise this thing in firebase?
Thanks in advance for yorur help