Latency issues I would like to understand better - Looking for a solution

[hk86]

Hi there,

I would like to better understand the latency issues I experience. This is my current setup:

• My nextjs app is deployed on Vercel [Hobby]
• On nextjs I have the API endpoint /api/graphql where an ApolloServer is created
• My data source is a MongoDB running on a root server in Frankfurt (Germany)
• Some pages use getStaticProps others getServerSideProps

I made some tests, where I used Postman to access the GraphQL endpoint:

1. Running a very simple query (without accessing my MongoDB) I see a response time of ~180ms
2. Running a query where a MongoDB query is executed I see a response time of ~350ms

I assume this is due to the fact that the enpoints are deployed to the region sfo (San Francisco)? So on 1. the execution is me -> SFO -> me and on 2. it is me -> SFO -> FRA -> SFO -> me. So when getStaticProps or getServerSideProps are executed this will happen as well in sfo? This is a big issue in case of getStaticProps the build time will take quite a while when 1000s of pages need to be created and in case of getServerSideProps the First Byte will be terrible.

So what options do I have?

1. I move the Serverless Functions closer to Frankfurt, for this I need to switch to a Pro plan?
2. Drop the /api/graphql endpoint and setup a GraphQL server in Frankfurt. I guess this will not fix the latency, since getStaticProps or getServerSideProps will be still executed in sfo.
3. Move my MongoDB closer to San Francisco (which is not an option)

Any further ideas how to tackle this latency issue?