What's the correct way to reuse connections in case of PHP and MySQL?

+5 A:

What do you mean be "reuse connections"? A connection is a socket being opened to the server..of course you can't store it in $_SESSION. It still would have to reconnect, so it would be pointless anyways. The closest you can come to it is persistent connections.

ryeguy 2009-08-25 17:41:06

reuse means:not close the connection after each request.So next request will save time.

Shore 2009-08-25 17:44:52

Well persistent connections do that. You still have to specify the connection like you normally would though; there is no other solution.

ryeguy 2009-08-25 17:47:11

+3 A:

Read about mysql_pconnect().

Unfortunately, persistent connection is not stable in PDO and not supported by MySQLi.

Persistent connections save time when the database server is not in the localhost, but if it is, use of persistent connections is practically irrelevant.

Havenard 2009-08-25 17:45:43

Also, if you are using PDO you can do something like:$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass, array(PDO::ATTR_PERSISTENT => true));

Kitson 2009-08-25 17:53:59

According to the PDO documentation, it is not entirely safe or recommended.

Havenard 2009-08-26 01:39:18

A:

use mysql_pconnect rather than mysql_connect

nont 2009-08-25 17:46:08

ansaurus

tags:

views:

answers:

What's the correct way to reuse connections in case of PHP and MySQL?

related questions