note 83632 added to function.mysql-fetch-object
| From: | strrevxc dot noxeh at ellij | Date: | Thu, 05 Jun 2008 12:28:08 +0000 |
| Subject: | note 83632 added to function.mysql-fetch-object | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-140140@lists.php.net to get a copy of this message | ||
I created a table, with 5 INT columns, and 1000 rows of random ints.
I did 100 selects:
SELECT * FROM bench... (mysql_fetch_object)
Query time: 5.40725040436
Fetching time: 16.2730708122 (avg: 1.32130565643E-5)
Total time: 21.6803212166
SELECT * FROM bench... (mysql_fetch_array)
Query time: 5.37693023682
Fetching time: 10.3851644993 (avg: 7.48886537552E-6)
Total time: 15.7620947361
SELECT * FROM bench... (mysql_fetch_assoc)
Query time: 5.345921278
Fetching time: 10.6170959473 (avg: 7.64049530029E-6)
Total time: 15.9630172253
"Note: Performance Speed-wise, the function is identical to mysql_fetch_array(), and almost as
quick as mysql_fetch_row() (the difference is insignificant)."
And I am a penguin :)
----
Server IP: 89.248.170.61
Probable Submitter: 82.93.241.107
----
Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-object.php
Edit -- https://master.php.net/note/edit/83632
Del: integrated -- https://master.php.net/note/delete/83632/integrated
Del: useless -- https://master.php.net/note/delete/83632/useless
Del: bad code -- https://master.php.net/note/delete/83632/bad+code
Del: spam -- https://master.php.net/note/delete/83632/spam
Del: non-english -- https://master.php.net/note/delete/83632/non-english
Del: in docs -- https://master.php.net/note/delete/83632/in+docs
Del: other reasons-- https://master.php.net/note/delete/83632
Reject -- https://master.php.net/note/reject/83632
Search -- https://master.php.net/manage/user-notes.php