Posted by Vince Morgan on 04/29/07 13:32

"john" <puopolo@gmail.com> wrote in message
news:1177851382.764835.310600@y80g2000hsf.googlegroups.com...
> All:
>
> I have a MS background and am having fun in the open source world of
> PHP and MySQL --- and I have a question.
>
> With PHP and MySQL, is it considered better practice to open a single
> database connection and re-use it throughout the life of the
> application (simple Web application - low traffic), or is it better to
> open a connection, use it and close it as needed?
>
> (With SQL Server, you'd do the latter, because connection pooling and
> other optimization mechanisms help ensure that connecting to the
> database is low cost.)
>
The latter is actualy very fast in php too. Surprisingly so.
Vince

[Back to original message]