PHP extension mysql vs mysqli for upgrade

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
Horinius
Posts: 12
Joined: 08 Nov 2013, 19:01

PHP extension mysql vs mysqli for upgrade

Post by Horinius »

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
Post Reply