Back

[RESOLVED] Child document fetch limit for relationships?

  • 0
  • Databases
Vedsaga
16 May, 2023, 15:14

I wounder if in-case of many relationship, what is the limit of child document that will be returned? If there is limit then what exactly is, and if no then what if 10^3 doc is linked πŸ‘€

And if there is limit then how we are supported to do pagination for next set of documents?

TL;DR
The user had a question about the fetch limit for child documents in relationships. They were wondering if there was a limit to the number of child documents that would be returned, especially in the case of multiple relationships. The solution provided was that there is currently no limit on the number of child documents that are returned. However, if pagination is needed, multiple requests would need to be made.
joeyouss
16 May, 2023, 16:36

Hi - do you mean the levels to which you can access relationships?

Vedsaga
16 May, 2023, 16:41

hi, nope nope, I mean in many relationship, there could n number doc could be linked, and as it could be infinite so when you query A right it return all the Z doc linked to it. So, is n is 1K documents will it return all 1K at once>

joeyouss
16 May, 2023, 17:08

maximum 3 nested relations, and no pagination I believe (you would need 2 separate requests).

Vedsaga
17 May, 2023, 05:07

no no I was not asking about layer of linking, this is layer of linking, I was not referring to this,

Vedsaga
17 May, 2023, 05:10

I was trying to ask, as there could be 3 doc which belong to collection Z could be linked to a document of collection A, and as right now when you fetch a document from collection A you get all 3 linked document.

Vedsaga
17 May, 2023, 05:11

Now, imagine 3 doc which belong to collection Z linked with a document of collection A will this time when you fetch a document from collection A result in returning all 1000 linked Z documents?

Vedsaga
22 May, 2023, 11:43

Seems, answer for now is yap infinity, you will get infinite documents... you can not limit the no child document you receive.

joeyouss
1 Jun, 2023, 19:58

Hey @Vedsaga , is this resolved? Actually, relationships is still in beta so we might not actually always have what you might be looking to implement, but, that being said, we definitely want to hear more features and things you want us to introduce into relationships. Feel free to open GH issue for anything you think should be a part.

Vedsaga
2 Jun, 2023, 04:35

yap, I will mark it resolved

Vedsaga
2 Jun, 2023, 04:36

[RESOLVED] Child document fetch limit for relationships?

Reply

Reply to this thread by joining our Discord

Reply on Discord

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