High Latency in Queries from Convex DB (1.5s per Request)
Hi Convex team,
I'm experiencing significant latency while querying data from the users table in my Next.js application's API route. Each request is taking around 1.5 seconds, even for simple queries like fetching a single user or a list of users.
I'm currently using the free plan of Convex. Could you please let me know:
1. Where is my database physically hosted (region or location)?
2. What might be causing this delay?
3. Are there any recommended steps to reduce the query response time?
I’d really appreciate any guidance on how to improve performance.
Thanks in advance!
11 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
I was experiencing some performance issues in the past couple of days as well - our functions went from ~50 ms to ~500 ms, seems to have been resolved now though. Maybe there are some transient issues with the servers?
I believe all servers are hosted in the US
Just to confirm — as a developer using the free plan:
Is there anything I can do from my side to reduce the query response time (e.g., optimizing functions, reducing payloads, or upgrading the plan)?
And if I upgrade, will I get access to region selection or better latency for apps hosted outside the US?
I'll let the team answer the two seconds points, but for point 1: yes there's probably always something you could do to improve performance, but 1.5 seconds is incredibly slow and should not be just because of a poor implementation on your side.
Is the 1.5 seconds the value you see in your dashboard logs, or what it "feels" like to you? i.e. what do your logs say (in my screenshot). And is it all functions or just some?
You can paste the slow function here and I can see if there are any obvious issues. common tips are to filter using indexes rather than .filter etc. : https://docs.convex.dev/understanding/best-practices/
Best Practices | Convex Developer Hub
This is a list of best practices and common anti-patterns around using Convex.
Here I added few screenshots how I am calculating the time of executing a function.
hi! do you have the in-dashboard times?
just to compare so we know where the slowdown is coming from
these look like one-shot invocations over HTTPS -- so there will likely be a whole connection establishment, TLS handshake etc etc, and then depending on where in the world you are...
so it'd be nice to isolate the server execution time vs. the entire protocol round trip stuff
Are you asking this?
In convex dashboard I can see it is showing only 126ms but, I shared with you a screenshot, how I am calculating the execution time of convex function using convex http client. Please take a look on the above codes as well and let me suggest a better way. or you have a time for a quick call, I can show you my code on the call properly.
126ms is a little long for that. does that function have an index?
Yes, the query does have an index, and the 126ms shown in the dashboard reflects only the server-side execution time.
However, in practice, it's taking around 2885ms to complete the process. I'm using the Convex HTTP client to first fetch the current user, perform some validation, and then fetch the list of users—both via separate Convex HTTP client requests. So while the function itself executes quickly, the total round trip time is significantly higher due to multiple Convex HTTP client calls and associated overhead.
If you're open to it, I'd love to hop on a quick 5-minute video call. I can walk you through the code and show exactly how I'm using the Convex client — it might help clarify the issue better.
I hope you're doing well. Could you please let me know if you're available for just 5–10 minutes? It would be extremely helpful for us to make the right decision regarding the database provider for our project.
If Convex can meet our needs, we're ready to move forward with the Pro plan. However, if it doesn't align with our requirements, we'll need to explore other options. We’re at a decision-making point, and a quick conversation would really help us move forward confidently.
Thank you!