News Feed
Jobs Feed
Sections

Recent Jobs

News Archive
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



Similar Posts

DevShed: PHP, MySQL and the PEAR Database

PHPBuilder.com: Reading RSS feeds in PHP: Part 2

Laura Thomson\'s Blog: Slides from MySQL Users Conference

DevShed: Using Advanced Functions to Maintain the State of Applications with PHP Sessions

DeveloperTutorials.com: Inserting An Array Into A Database


Community Events









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


framework zendframework code zend PHP5 security job package conference cakephp database releases example book application developer PEAR release mysql ajax

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