Efficiency of mysql_close()

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

  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

  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

  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.

Re: Efficiency of mysql_close()

Quoted text here. Click to load it

Open the connection once at the top, then forget about it.  Opening it
for each and every query is wasteful (the overhead to connect is
generally high).  You don't need to close it explicitly, either -- it
will be closed automatically when the script is done.

Site Timeline