#50571 [NoF->Opn]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6

From:	millennium at qme dot nl	Date:	Sat, 09 Jan 2010 18:54:22 +0000
Subject:	#50571 [NoF->Opn]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-146492@lists.php.net to get a copy of this message

 ID:               50571
 User updated by:  millennium at qme dot nl
 Reported By:      millennium at qme dot nl
-Status:           No Feedback
+Status:           Open
 Bug Type:         MySQLi related
 Operating System: Windows Server 2003
 PHP Version:      5.3.1
 New Comment:

see feadback 25 dec.


Previous Comments:
------------------------------------------------------------------------

[2010-01-01 01:00:01] php-bugs at lists dot php dot net

No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

------------------------------------------------------------------------

[2009-12-25 00:41:08] pajoye@php.net

That's expected as mysqlnd uses php's stream. That brings a small
overhead over raw sockets.

------------------------------------------------------------------------

[2009-12-25 00:39:23] millennium at qme dot nl

If I move the connect and disconnect outside the loop, the speed is 
the (almost) the same.

php 5.2.6:
time: 0.27 secs, memory usage 0.15 MiB.
php 5.3.1:
time: 0.28 secs, memory usage 0.40 MiB.

moving the connect inside the loop again (keeping the disconnect 
outside)

php5.2.6:
time: 1.82 secs, memory usage 0.15 MiB.
php5.3.1:
time: 31.11 secs, memory usage 0.40 MiB.

So I guess it's the connect.

------------------------------------------------------------------------

[2009-12-25 00:25:35] scottmac@php.net

Can you adjust your test to see if its the connection, the query or the
closing that's causing the problems?

------------------------------------------------------------------------

[2009-12-24 23:26:32] millennium at qme dot nl

C:\php2>php sync.php
time: 28.37 secs, memory usage 0.40 MiB.

C:\php2>php -v
PHP 5.3.2-dev (cli) (built: Dec 22 2009 09:57:39)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2009 Zend Technologies

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/50571

-- 
Edit this bug report at http://bugs.php.net/?id=50571&edit=1



   

Thread (8 messages)

• millennium at qme dot nlThu, 24 Dec 2009 23:01:40 +0000
  • jani@php.netThu, 24 Dec 2009 23:19:06 +0000#50571 [Opn->Fbk]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
  • millennium at qme dot nlThu, 24 Dec 2009 23:26:33 +0000#50571 [Com]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
  • scottmac@php.netFri, 25 Dec 2009 00:25:36 +0000#50571 [Fbk]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
  • millennium at qme dot nlFri, 25 Dec 2009 00:39:24 +0000#50571 [Com]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
  • pajoye@php.netFri, 25 Dec 2009 00:41:09 +0000#50571 [Fbk]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
  • millennium at qme dot nlSat, 09 Jan 2010 18:54:22 +0000#50571 [NoF->Opn]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6
  • jani@php.netSat, 09 Jan 2010 19:19:54 +0000#50571 [Opn->Bgs]: Performance Mysqli in php 5.3.1 signific slower than 5.2.6