There is a problem with the performance of database queries.

Is it possible to limit the depth of the request when receiving a document?

I noticed a large performance drawdown when a table of not many relationships is obtained. Is it possible, like sql, to simply get an id from related objects.

How to speed up query performance?

TL;DR

There is a problem with the performance of database queries. One suggestion is to not use relationships and store the ID as a string instead. However, this may not be possible as relationships are supported up to three levels. Another suggestion is to retrieve specific fields from the related object instead of all of them. It is mentioned that queries on relationships are not currently supported. There is a mention of limiting the depth of the request when receiving a document. The user noticed a performance issue when obtaining a table with few relationships and asks if it is possible to only get the ID from related objects like in SQL. The user also asks for tips on how to