Gunshot
DTDrizzle Team
•Created by Gunshot on 8/20/2024 in #help
Timeout issues on vercel
Hey everyone,
I have a remix app hosted on vercel along with a turso DB (functions and db are on the same region) and i have been facing some unexpected issues lately.
On my index route im running a query that is often expected to return a larger number of rows, and since im using the query syntax it also aggregates relations. When running a query inside of my loader function here https://github.com/VaggelisKa/my-desk/blob/main/app/routes/_index.tsx it often fails on vercel because of a timeout. While on my local dev environment the query executed and resolves in sub 1s time. The same for when i run the raw sql on the DB.
Any idea what can create this large discrepancy of time on a production env? Even if i increase the vercel timeout to 45s it would still result in a timeout. So i must not be seeing a big bottleneck here
1 replies