View Single Post
  #7  
Old 08-23-2007, 12:25 PM
 
intel352 intel352 is offline
 

X-Wizard
  
Join Date: Dec 2005
Posts: 1,071
 

Default Re: Converted X-Cart 4.1.18 to use mysqli instead of mysql

A simple preliminary page benchmark using X-Cart's benchmark utility shows pretty much the same performance on the homepage. I'll do more testing later on style & category pages.

Quote:
Originally Posted by MySQL
[23-Aug-2007 13:15:13] (shop: 23-Aug-2007 13:15:13) BENCH message:
PHP: time: 0.1090 (54.75%); reference points: 67 (37.85%)
SQL: time: 0.0342 (17.2%); reference points: 87 (49.15%)
SMARTY: time: 0.0559 (28.07%); reference points: 23 (12.99%)
Full time: 0.1991
Used memory: 1.091
Max. used memory: 1.272
Max. saved session data: 2.475
Request URI: /home.php
-------------------------------------------------
[23-Aug-2007 13:15:18] (shop: 23-Aug-2007 13:15:18) BENCH message:
PHP: time: 0.0893 (49.92%); reference points: 68 (37.99%)
SQL: time: 0.0344 (19.21%); reference points: 88 (49.16%)
SMARTY: time: 0.0553 (30.88%); reference points: 23 (12.85%)
Full time: 0.1789
Used memory: 0.999
Max. used memory: 1.181
Max. saved session data: 2.475
Request URI: /home.php
-------------------------------------------------

Quote:
Originally Posted by MySQLi
[23-Aug-2007 13:08:44] (shop: 23-Aug-2007 13:08:44) BENCH message:
PHP: time: 0.0983 (52.91%); reference points: 71 (38.38%)
SQL: time: 0.0326 (17.54%); reference points: 91 (49.19%)
SMARTY: time: 0.0549 (29.57%); reference points: 23 (12.43%)
Full time: 0.1857
Used memory: 1.072
Max. used memory: 1.247
Max. saved session data: 2.475
Request URI: /home.php
-------------------------------------------------
[23-Aug-2007 13:10:01] (shop: 23-Aug-2007 13:10:01) BENCH message:
PHP: time: 0.0897 (50.37%); reference points: 67 (37.85%)
SQL: time: 0.0342 (19.24%); reference points: 87 (49.15%)
SMARTY: time: 0.0541 (30.41%); reference points: 23 (12.99%)
Full time: 0.1780
Used memory: 0.980
Max. used memory: 1.161
Max. saved session data: 2.475
Request URI: /home.php
-------------------------------------------------
__________________
-Jon Langevin
WARNING: Unethical developer - NOT RECOMMENDED
See details here
Reply With Quote