I have read a bit on the topic and experiment on local machine using Astro fetch() from my database.
https://docs.astro.build/en/guides/server-side-rendering/#using-streaming-to-improve-page-performance
https://docs.astro.build/en/guides/server-side-rendering/#streaming
Astro is running behind Nginx reverse proxy, I'm not quite sure how a fetch is call to my database on a production VPS doesn't seem to improve performance?
Which browsers support HTTP Streaming? Is it refer to HTTP live Streaming?
I was assuming the fetch call would be a short round-trip latency (both Astro and database on the same machine) but in my benchmark test, the requests throughput dropped significantly as the page adds more fetch request.
Home page, SSR, no fetch()
300+ req/s
Home page, SSR, 1's fetch() in component/test.astro
190+ req/s
Home page, SSR, 5's fetch() in component/test.astro
50+ req/s
Benchmark using wrk tool.