Custom query resolver + rules = terribly slow on a large collection

[rouuuge]

Not really, at the moment there are just 4000 Events for that user. So that user would have access to all documents. The performance issue is here. So for every Events it checks those two other collections. First to find the person details, and after to check if the user is a admin member.

@rouuuge

case "events":
    return personCollection.findOne({ _id: user.id }).then(person => {
      if (person && person.teams && person.teams.length > 0) {
        return teamCollection.findOne({ _id: person.teams[0] }).then(team => {
          const isAdmin = team.membersAdmin.find(m => m === user.id) !== undefined;
          console.log('is user admin for this team?', isAdmin);
          return isAdmin;
        }, error => {
	       console.log(`Unable to write Event document: ${error}`);
	       return false;
	      });
      }
    }

Maybe its a schema design issue. But for the IOS-App its fast!