News Feed
Jobs Feed
Sections




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

MySQL Performance Blog:
Are PHP persistent connections evil ?
November 14, 2006 @ 09:03:00

The MySQL Performance Blog takes a look today at a more PHP-related topic - persistent connections in PHP and whether or not they are the devil (well, okay, so maybe not quest that bad - just a little evil).

The reason behind using persistent connections is of course reducing number of connects which are rather expensive, even though they are much faster with MySQL than with most other databases.

They go on to talk about:

  • issues with the number of active connections that could come up
  • the use of too many connections at once
  • why persistent connections are disabled in the new mysqli extension
Their conclusion? Persistent connections are not evil. In fact, they're very good, when used in the right context and for the right kinds of queries. There's also a small push for an even newer MySQL driver for PHP by the MySQL team - the "mysqlnd" driver.

0 comments voice your opinion now!
mysql persistent connections evil active disabled mysqli mysqlnd mysql persistent connections evil active disabled mysqli mysqlnd


blog comments powered by Disqus

Similar Posts

Edin Kadribasic's Blog: PHP 4.4.3 for Windows with 5.0.22 MySQL libraries

PHPClasses.org: Lately in PHP, Episode 32 - Zend Optimizer+ Cache in PHP 5.5 & MySQL 5.6

MySQL Performance Blog: Are PHP persistent connections evil ?

HowToForge: How To Install a Complete LEMP on Ubuntu/Debian

DevShed: Paginating Result Sets for a Search Engine Built with MySQL and PHP 5


Community Events











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


release framework facebook application package install hhvm composer performance symfony2 language project hack security example component database podcast introduction unittest

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