Slow query due to relations

I make this simple query:

'''
databases.listDocuments(
databaseId: AuthenticationState.databaseId,
collectionId: BalanceCollectionId,
queries: [
Query.equal('user_id', localUser.$id),
],
);
'''

The balance collection is a simple collection with 600 entries. However it has relations to other collections, which had relations to others etc.

My assumption is that it is being slowed down because of nested relations. If all relations are called, a lot of data is requested.

This single call does take 10 seconds however, which seems excessive.

Does someone have a direction to solve this? Remove the relations and fetch them myself?

In my Appwrite console I also get this error all the time: 'cloud.appwrite.io | 524: A timeout occurred'

Remove the relations and do it yourself when necessary. Relations are in beta and may lead to performance issues.

Otherwise, if you don't need that data and want to leave the relations you can use query select and select everything but the related attribute, but if you do need that related data there isn't a way of speeding it up right now.

@Kenny thanks for the reply. Is is possible to query select in such a way that you get the relation id however not all data behind that relation. E.g for a balance relation, I just want the balance ID, not all balance data

You may be able to do Query.select('related_item.$id') but know this isn't an officially supported functionality.