We are fetching 3.3 million data from postgres DB on heroku, it's getting timeout error. it's working well on local
This is error message.
heroku[router]: at=error code=H12 desc="Request timeout" method=POST path="/api/product-codes/generate" host=[login to view URL] request_id=0c02eef4-888c-40ed-aaa2-b59ffb4c7e68 fwd="[login to view URL]" dyno=web.1 connect=0ms service=30000ms status=503 bytes=0 protocol=https
Faced this issue before and I am willing to give you help. Meanwhile, I am professional in HTML, CSS, JAVASCRIPT, React-Redux, Node-Express with PostgreSQL, MySQL, MongoDB, Git, and Docker together with LINUX SERVER, AWS, etc....
hello
Thank for your job posting
I just read your job description and I think it's a great fit for your project.
Please look forward to the best beautiful results.
I've done similar things in the past
With my rich experience, your project can be completed perfectly and beautifully.
Also i can work in your timezone
Thanks for your time.
GREETINGS DEAR CLIENT,
CERTIFIED EXPERT IN NAMED SKILLS,
Dear Client, I have Keenly gone through your project requirements as given in your project description. I gladly inform you that i am in possession of all clearly stated required skills (PostgreSQL, Heroku, JavaScript and Node.js) as this is my area of professional specialization having completed all engineering certifications and developed adequate experience in this field. I humbly request you to consider my bid for professional and quality services always, with no timeline and quality excuses, and 100% client satisfaction guaranteed.
Message me we discuss more about the project.
THANK-YOU and WELCOME.
Hi there!
Regarding the timeout error you are experiencing when fetching data from your Postgres DB on Heroku.
Based on the error message you provided, it seems that the request is taking longer than 30 seconds, which is the default timeout for Heroku. This could be due to a number of factors, including the size of the data you are fetching and any network latency between your Heroku app and your database.
To resolve this issue, I would suggest optimizing your database queries to retrieve only the necessary data and minimizing the amount of data transferred between your database and Heroku. Additionally, you may want to consider upgrading your Heroku plan to a higher tier to increase the performance and resources available to your app.
I have some solution in mind, and I would be happy to assist you further in diagnosing and resolving this issue. Please let me know if you would like to discuss this in more detail or if you have any further questions.
Thank you for considering my proposal, and I look forward to hearing from you soon.
I have understood the error you are facing!! There are several things I need to clarify before taking up this job, but I believe I can fix this. You can contact me via email and we can discuss this further.
Hi!
I am a Full stack developer. I came across your post and you need to resolve an timeout error. I have done many projects like that and I believe that my professional skills and working experience make me eligible for this project. Lets have a quick chat.
Thank You Bilal.