Skip to content
Start building
Back

Relationship performance between collections in the appwrite cloud solution.

  • 0
  • Databases
  • Cloud
View on Discord
Colin Abal
8 Aug, 2025, 09:26

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.

TL;DR
Developers are worried about the performance of relationships between collections in Appwrite Cloud. They are concerned about the number of queries when fetching related data and how it impacts database performance. They are also curious about how Appwrite Cloud handles querying students in a collection table and the performance limitations with large-scale data.
Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more