PHP extension mysql vs mysqli for upgrade

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
matthewbartlett
Posts: 1
Joined: 26 Aug 2019, 09:38

PHP extension mysql vs mysqli for upgrade

Post 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
TerranceM
Posts: 26
Joined: 27 Aug 2019, 13:55
Location: USA

Re: PHP extension mysql vs mysqli for upgrade

Post by TerranceM »

This is helpful. With the help of that command, I can also track the performance of my DB.
Post Reply