data optimization
Hello everyone, I'm really stuck and need help. I have a PostgreSQL database running with Docker on my VPS server. I was given a CSV file with over 60,000 rows, and my Next.js application is hosted on the same VPS. On my local machine, it works fine with no delay or timeout. However, after deploying, I noticed it was extremely slow. Most times, the requests time out because I'm trying to fetch all the data to create a dashboard. I think the problem might be related to how I'm making the database calls. I would be really grateful if someone could hop on a call or review my code to see what I can change to improve performance.
here is the github link
https://github.com/alidauda/Analysis-
GitHub
GitHub - alidauda/Analysis-
Contribute to alidauda/Analysis- development by creating an account on GitHub.
2 Replies