java - Firebase gets slower when counting products from the database (Android)

Question

I have a database of sport products. Users can add as many products as they want, as long as the products are correct and are approved by the admin. Everything works fine but in the last month, I checked the app and it start to work very slow. I checked that on real device as well as in an emulator. Same behaviour. I think that the problem is that the number of products is constantly growing and to count the products is even harder. Can anyone help me solve this problem? Thanks!

Code:

FirebaseDatabase.getInstance().getReference("sport_products").addListenerForSingleValueEvent(
        new ValueEventListener() {
            @Override
            public void onDataChange(DataSnapshot dataSnapshot) {

                int productCount = (int) dataSnapshot.getChildrenCount();

                for(DataSnapshot productSnapshot : dataSnapshot.getChildren()) {

                    //Code to process the data

                }
            }

            @Override
            public void onCancelled(@NonNull DatabaseError de) {}
        }
);

Answer 1

Waitting for answers