是否可以为所有用户只打开一个数据库连接？

Question

Need a suggestion from you guys.

I am using a CI application and when I do Load test application with 100 users each time it opens a new connection and after that when I see cloud monitoring it shows 100 open connection and utilization up to 80%.

How can I reduce that?

Thanks

Answer 1

1. Open a db connection
2. Save the db connection object to a file
3. For every use instance, load the connection object from file