I have just done a database upgrade (using the "admin/install.php") from Mantis 1.1.6 to Mantis 1.2.15 using PHP extension mysql vs mysqli to see the performance difference. Except PHP extension, all the other things are exactly the same. I hope this post of mine could be helpful to those who need it.
Conditions:
CPU: 2.666GHz 2-core (virtual machine)
Windows Server 2003 R2 Standard Edition 32-bit
Apache version 2.4.6
MySQL version 5.5.34
PHP version 5.4.22
Database size: 230 MB
Results:
mysql: 3 min 35 sec
mysqli: 2 min 21 sec
PHP extension mysql vs mysqli for upgrade
Moderators: Developer, Contributor
Re: PHP extension mysql vs mysqli for upgrade
This is helpful. With the help of that command, I can also track the performance of my DB.