News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Maggie Nelson's Blog:
To persist or not to persist?
August 22, 2008 @ 11:18:12

On her blog, Objectively Oriented, Maggie Nelson looks at a topic she was debating for a new application - whether or not to use persistent connections to her database.

There's a connection already waiting for you. Yay, right? Well, with MySQL, connecting is actually really really cheap, and frankly, if you are using persistent connections, you might encounter some issues with Apache going zombie on processes that use a connection, effectively taking that connection out of use. Grrr.

She did some research on the topic but found contradicting evidence for both sides. Eventually, what her choice boiled down to was this possible issue mentioned by Jay Pipes (of MySQL):

If you use Apache, Apache can zombie a PHP process and cause the mysql connection to be held until the mysql server restarts...
0 comments voice your opinion now!
persistent connection database mysql choice


blog comments powered by Disqus

Similar Posts

Alison Holloway's Blog: Int'l PHP Magazine Article - The Oracle PHP Connection

Damian Sromek's Blog: [How to] Run PHPUnit tests using database 10x faster

PHPBuilder.com: MySQL and PHP: How to make it work without killing your server

Davey Shafik\'s Blog: Filtering & Escaping Cheat Sheet

Gonzalo Ayuso: Handling several PDO Database connections in Symfony2 through the DIC in PHP


Community Events





Don't see your event here?
Let us know!


introduction community opinion laravel library language conference symfony voicesoftheelephpant tool artisanfiles podcast framework version list series security composer interview release

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework