I deployed my NextJs app to Vercel. Static pages works great. But the api part (pull data from an azure sql database, async mssql) behaves inconsistent, sometimes it returns the expected response, sometimes it doesn't. When I tested it on my local machine, everything worked great, so I don't think it's code related. Is this a known issue with NextJs api on Vercel?
I have tried to deploy my NextJs app to Azure, it had all kinds of weird errors. I have also tried to deploy the app as a docker image, and created an azure web app using the docker image, it works, but loadtime is horrible. I am curious if you have experienced similar performance issues when creating an web app on azure using a docker image.
Any input is appreciated. Thanks