Page 1 of 1

PHP extension mysql vs mysqli for upgrade

Posted: Aug 26, 2019 4:39 am
by matthewbartlett
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

Re: PHP extension mysql vs mysqli for upgrade

Posted: Dec 16, 2019 11:48 am
by TerranceM
This is helpful. With the help of that command, I can also track the performance of my DB.