Is it appropriate to continuously keep the connection to the database until the end of the rendering of the web page?

Question

PHP

For example, a page needs to perform 10-20 (sometimes more) database queries when rendering the page. Making one large query is too tedious and inconvenient, and 10 small queries are executed very quickly if you do not disconnect from the database every time. Actually the question is whether there is an alternative or is it okay if the connection lasts for two seconds continuously?

Answer 1

Use the pool to maintain connections with MySQL, you don't need to establish a new connection, use the old one

Answer 2

Yes.

Answer 3

Absolutely, there's nothing wrong with that. For the database - an already open connection does not give any load from the fact that it did not close within 1 sec, 10, 1000 sec.