note 102711 added to mysqli.query

From: Date: Tue, 01 Mar 2011 21:19:59 +0000
Subject: note 102711 added to mysqli.query
Groups: php.notes 
Request: Send a blank email to php-notes+get-177464@lists.php.net to get a copy of this message
I just want to let people know of my findings of testing MySQLi VS standard SQL Query. Overall: I tested running 99,999 Rows in the database to the browser, testing on my local laptop machine and my Server Down in the states. LOCAL MACHINE: Standard SQL == (avg load = 3.304sec) Standard SQL == (avg mem = 95.18 KB) MySQLi == (avg load = 3.513sec) MySQLi == (avg mem = 96.59 KB) MEDIA TEMPLE: Standard SQL == (avg load = .984sec) Standard SQL == (avg mem = 83.11 KB) MySQLi == (avg load = 1.295sec) MySQLi == (avg mem = 82.38 KB) So Really, my thought is, why is MySQLi slower??? ---- Server IP: 69.147.83.197 Probable Submitter: 154.20.218.134 ---- Manual Page -- http://www.php.net/manual/en/mysqli.query.php Edit -- https://master.php.net/note/edit/102711 Del: integrated -- https://master.php.net/note/delete/102711/integrated Del: useless -- https://master.php.net/note/delete/102711/useless Del: bad code -- https://master.php.net/note/delete/102711/bad+code Del: spam -- https://master.php.net/note/delete/102711/spam Del: non-english -- https://master.php.net/note/delete/102711/non-english Del: in docs -- https://master.php.net/note/delete/102711/in+docs Del: other reasons-- https://master.php.net/note/delete/102711 Reject -- https://master.php.net/note/reject/102711 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#177464) next »