[steelbrain]

Hello! How are you collecting your edge workload to the database? Are you using cloudflare’s database?

I’ve wanted to try out this edge hosting thing but because of the amount of round trips involved between the application and the database, the application performs worse on the edge.

Thanks!

[l5870uoo9y]

The database is hosted on Railway. I have enabled Smart Placement that should, depending on request time, automatically use an endpoint closer to the database to speed it up. When requesting a route that includes a database request, the response time on the US east coast is around 200ms and closer to 1000ms in Denmark. I am hoping that the Smart Placement will work better when I go live with the app (still in beta) and that it mainly needs more traffic to calculate optimal endpoint placement.

[lukecarr]

Have you given Hyperdrive[0] a try? In theory, it should improve performance in your use case where you have a central database (Railway) being connected to from the Edge (your Workers).

It moves the DB connection logic closer to your Workers, pools connections, and can also cache queries.

(Disclaimer: I work for Cloudflare, but on an unrelated team. Not personally used Hyperdrive, but heard good things!)

[0]: https://developers.cloudflare.com/hyperdrive/

[pjc50]

So a remote, authenticated DB connection over the internet? How many db queries per page generation does that generally work out as?