Web Developer
Say I have a collection of "teachers" and "students" where a teacher has a relationship-attribute to asign multiple students to one teacher.
When I fetch data from 1 specific teacher will it perform several other queries per student? so a teacher with 30 students asigned, will have 31 database queries(1 for the teacher + 30 for students)?
If so, in what way does it query / lookup those students in the student collection-table? Does it query based on the ID's, an index or a reference within the student collection?
I am a front-end dev. so , so far I have never had to worry about database performance. We are about to use this on a large scale, so I wonder what kind of performance limitations I will hit within the Appwrite Cloud. Especially when we have 500.000 to 1.000.000 documents in a collection/table.
Thank you for your patience and understanding in advance.