note 83632 added to function.mysql-fetch-object

From: 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

« previous php.notes (#140140) next »