|
When and how often is it good practice to start the connection to your database in php? I'm new to databases, and I'm wondering when I should start by database connection. I'm creating a api with an index, controllers and model. Should I start the connection in the index and then pass it to all the other files, start the connection at the top of all files and call it as a global in functions as needed or start and end the connection in every function? |
|||||
|
Questions on Server Fault are expected to relate to professional server, networking, or related infrastructure administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.
|
Opening a database connections is expensive, so cycling them in every function should never be done. Instead, you open a connection at most one time during a run of your script and utilize this throughout the whole request. In the optimal case (and mandatory for high load services), you should try to utilize persistent database connections wherever possible. This allows you to use an open connection from a previous run of the script but this is not possible in every scenario and also requires special care to make sure database operations from two script runs are properly separated. |
|||
|
|
