Posted by huckphin on 06/04/07 16:23

Hello,

I am working on a script for PHP that handles mysql_connections.
Right now, each time I query the database, i open the connection using
mysql_connect(), and after I get my resource result, I use
mysql_close(). I have heard from many people that it is common
practice to open a connection at the beginning of the script, and
since the connection closes at the end of the script, it is then
closed.

My question is this: Which is the better way? To open the script
at the top, and then let the connection close at the bottom? As this
may be a controversial issue, and if no answer is found, what are the
advantages?

Does anyone know if the resources used, and the time elapsed to make
a db connection is significant enough to warrant leaving the
connection open the entire time?

What are the advantages?

Thank you.

[Back to original message]