I am using a mysql database, that involves gathering photos and peoples names and exhibiting them on the page whenever a dropdown food selection is chosen. I'm being able to access the database having a php script.
I'm accustomed to requiring to needing to re begin a connection each time I access the database (I compromised around also it labored) however i want this code to appear a little more professional. Does anybody know a method to leave an association towards the database open, to ensure that I don't have to re begin a connection each time I create a request data?
I suppose you mean keeping the bond open across multiple calls towards the server. Inside the same script, you need to just open the bond once.
The mysqli documentation shows how you can enable persistent connections.
However, you need to benchmark your code to make sure that hooking up towards the database can be a performance-restricting factor. You are able to most likely find bigger returns by analyzing the interplay involving the application, the queries, and also the schema.
Using the older mysql_pconnect function, you can run directly into issues where old customers of the connection left things inside a non-clean condition:
The issue with persistent connections is they could be left in unpredictable states by clients. For instance, a table lock may be triggered before a customer terminates suddenly. A brand new client process re-using this persistent connection can get the bond "as is". Any cleanup will have to be carried out by the brand new client process before it might make good utilisation of the persistent connection, growing the responsibility around the programmer.
The mysqli logic does a lot of cleanup for you personally to ensure that this is not an problem.
In the documentation, the cleanup includes:
- Rollback active transactions
- Close and drop temporary tables
- Unlock tables
- Totally reset session variables
- Close prepared claims (always happens with PHP)
- Close handler
- Release locks acquired with GET_LOCK()