More information about MySQLi can be found here: http://www.php.net/mysqli and http://dev.mysql.com/doc/refman/5.0/...ql-mysqli.html
Using MySQLi with vBulletin might not give you huge benefits, but I have it turned on for my setups.
Some of the benefits of using MySQLi (improved) are:
- support for transactions for the storage engine InnoDB (autocommit, commit and rollback)
- prepared statements
- secure mysql connections
- multi query
- object oriented interface
More details about these benefits can be found here: http://www.charlesrowe.com/2007/06/1...its-of-mysqli/
And to save time here’s a great article for experienced developers: http://devzone.zend.com/node/view/id/686
In regards to vBulletin, once you check phpinfo(); and see you can use MySQLi you can go to your config.php file and set $config['Database']['dbtype'] to mysqli, default is mysql.
$config['Database']['dbtype'] = ‘mysqli’; And if your tables and HTML charset are set to UTF-8 you can also set $config['Mysqli']['charset'] to utf8, default is uncommented. And $config['Mysqli']['ini_file'] to ”, default is ”.
$config['Mysqli']['charset'] = ‘utf8′; $config['Mysqli']['ini_file'] = ”; Again, I now have my forums use MySQLi and I have no problems, but do not notice a great improvement. I am just happy to think that vBulletin can make use of it.