Appwrite Cloud Delay from hosted in Frankfurt Germany to North America West (Utah)

[south maple]

So I was asked by @hazy stirrup to create this post, so it can be discussed further

Ive added the tags that correlate to my project and what i mostly use and where i see the delay being

Attached image is the point where i create a Email Password Session and based off the user information i will request additional information like the latest news posts for the website

In my previous message i left a statement where i would see 2.5 second delays for single GET request, and when it does more than 1 it takes 6 - 10 seconds, these are in my more heavier spots, but the login combined takes 6 secs based off a stop watch time.

I can add more data if needed

[jolly ravine]

according to the screenshot you shared, the create email session api call takes ~500ms 🧐

the list documents is taking a while...

1. can you use getDocument() instead of listDocuments()?
2. do you have relationships?

[south maple]

the documents use alot of relationships, im guessing your pointing that out, so it may be the culprit to my entire issue here?

[jolly ravine]

yes. lots of relationships can slow things down a lot

[south maple]

Okay that also explains why things are alot faster when no relationships are used

why are they so slow?

[jolly ravine]

For every document, for every relationship, Appwrite has to do an additional db query because the data needs to come back nested and permissions needs to be considered at the collection or document level

And relationships go as far as 3 levels deep