pconnect

[eluser][email protected][/eluser]
Hey guys,

I've read about persistent connections and still can't make up my mind on which one to use. The database will be hit every page w/ about 10 (SELECT) queries, and there will also be occassional UPDATE & INSERT queries but not nearly as often.

Should pconnect be used ? Why? or Why not?

Thanks

[eluser]Jon L[/eluser]
pconnect with PHP/MySQL should not be used, unless you're using the new MySQLnd driver.

PHP mysql support for persistent connections is poorly implemented
PHP mysqli dropped any support for persistent connections
PHP mysqlnd is being developed over the top of mysqli to add support for persistent connections

MySQLnd (MySQL Native Driver) - http://dev.mysql.com/downloads/connector/php-mysqlnd/

[eluser]barbazul[/eluser]
Adding to Jon L's post: MySQLnd will be included in the next release of PHP 5.3 which should take place in the upcoming weeks (considering everybody stops whining about the namespaces separator)