CODEWITHSUNDEEP
phpmysqlmysqlipersistent-connection
waqas
waqas

Reputation: 91

What are the purpose and benefits of using persistent connection in mysql?

According to php manual:

Persistent connections are not closed at the end of the script, but are cached and re-used when another script requests a connection using the same credentials. The persistent connection cache allows you to avoid the overhead of establishing a new connection every time a script needs to talk to a database, resulting in a faster web application.

One advantage is efficiency that we do not need to make connection each time script executes. What are other advantages of persistent connection? Like query cache etc?

Upvotes: 3

Views: 1740

Answers (1)

Jameel Ahmed
Jameel Ahmed

Reputation: 11

it Allows for resumption of transactions across multiple request as well as Allow connections setting such as character set encoding to persist

Upvotes: 1

Related Questions