Anyway, one thing that it seems I could still optimise is my database connections, as phpBB still seems to be using a single connection per user with no persistency.
Now it looks like in /includes/db/mysqli.php that persistency is now supported for php 5.3 and onwards, which is fine, however as far as I can tell there's no correct way to enable persistent connections.
Someone correct me if I'm wrong, but the database connection is established by common.php on the following line (108):
Code: Select all
$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, defined('PHPBB_DB_NEW_LINK') ? PHPBB_DB_NEW_LINK : false);
So does this mean that persistent connections are unsafe to use, or is it okay to simply switch this to true? If it's okay to use, can anyone comment on how much of a difference (if any) it ought to make to performance on a large site (typically around 200 to 300 concurrent users)?
Lastly, if the feature is safe to use, should I make a bug report to see the persistency setting correct somehow?