Hello,

I have this line in my application which has become very slow due to the volume of members i have in my app:

var students = ApplicationContext.Current.Services.MemberService.GetMembersByMemberType("Pupil");

all the students in the app have a number property 'teacherId'. Instead of pulling back all the members on the site first before checking which ones have the teacherId im looking for, is it possible to write the SQL to be able to get all the students for a specific teacher id with one call?

Any help is appreciated!