reduce firestore reads - Githubissues

kikmann / my-sports-challenge-issues

Issues for my-sports-challenge

0 stars 0 forks source link

reduce firestore reads #63

Closed kikmann closed 5 months ago

kikmann commented 5 months ago

likely we need to monitor them

kikmann commented 5 months ago

likely access to trainings and users are cost factors

maybe cache some results ?

kikmann commented 5 months ago

added impact counter in mydb

Bottlenecks by now:

challengeget dominated by number of users
challengetrainingget dominated by number of trainings
challengeleaderboardget dominated by number of trainings

kikmann commented 5 months ago

By far the biggest table will be the training table for big/long challenges. Encapsulated access in mycache module All modifications to the table need to mark the cache indicator dirty.

kikmann commented 5 months ago

Next thing to be considered can be to in/exclude the users in the default page load. Normally this should not harm, but for large challenges this could be a pain if pages are loaded often.