|
|
Posted by ZeldorBlat on 06/04/07 16:27
On Jun 4, 12:23 pm, huckphin <chad.rhy...@gmail.com> wrote:
> 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.
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.
Navigation:
[Reply to this message]
|