MySQL performance again MySQLi

Question

I am upgrading older code from mysql_ to mysqli and i found myself writing a replacement for the common :

mysql_result();

What i wrote was :

function mysqli_result($res, $row, $field=0) { 
$res->data_seek($row); 
$datarow = $res->fetch_array(); 
return $datarow[$field]; 
}

But im curious, is there anyway to precisely benchmark the two without hindering any performance speed and if so what would be the best way about it ?

Mysql_result were the worst worst way of getting data from mysql. there is no point in dragging it into brave new world of mysqi, nor in any benchmarks — Your Common Sense, Jul 15 '13 at 15:00
possible duplicate of [Which is fastest in PHP- MySQL or MySQLi?](http://stackoverflow.com/questions/171400/which-is-fastest-in-php-mysql-or-mysqli) — Kermit, Jul 15 '13 at 15:09

Jason McCreary · Accepted Answer · 2013-07-15T15:07:24.570

2

The mysql_* functions will be deprecated in PHP 5.5. It is not recommended for writing new code as it will be removed in the future.

With that said, concerns of benchmarks and performance are irrelevant. Furthermore, following the 80/20 rule, optimization should be focused on your queries and DB structure well before code.

Nonetheless, I did run my own simple benchmarks years ago when making the switch. I found mysqli to be more performant than mysql. Moreso when using prepared statements.

As noted by Your Common Sense, performance is also heavily dependent on how you write your code. Be sure you understand the difference in the libraries and which methods to use.

edited Jul 15 '13 at 15:07

answered Jul 15 '13 at 15:02

Jason McCreary

71,546
23
135
174

Thats fair enough, i guess its just my own curiosity which is interested in the benchmarking of db queries ! – Pogrindis Jul 15 '13 at 15:03
1

@Pogrindis benchmarking this function has nothing to do with benchmarking db queries. – Your Common Sense Jul 15 '13 at 15:05
of course, but the query times of the same tables using both methods would be interesting to know, out of mild curiosity i guess. – Pogrindis Jul 15 '13 at 15:09
I queried the same table with the same `INSERT` and `SELECT` queries, `mysqli` was more performant. – Jason McCreary Jul 15 '13 at 15:10
@FreshPrinceOfSO, that question is 5 years old. Clearly the `mysqli` extension has established its supremacy since then. – Jason McCreary Jul 15 '13 at 15:11
Thanks Jason for this. – Pogrindis Jul 15 '13 at 15:12
@FreshPrinceOfSO, with `mysql` deprecated, I'd say `mysqli` won out. Furthermore, the *i* does stand for *improved* :) – Jason McCreary Jul 15 '13 at 15:14
@FreshPrinceOfSO, you brought up the *2008 model*. I'm just saying that 5 years later the top answer of that question my no longer be right (noting `mysql` is faster than `mysqli`). – Jason McCreary Jul 15 '13 at 15:16

score 1 · Answer 2 · answered Jul 15 '13 at 15:14

1

MySQLi is an 'Improved' way of interfacing with the same database, it has many memory and speed enhancements in addition to support for;

Prepared Statemments
Multiple Statements
Transactions

MySQLi can also be written in both OOP style and procedural style.

If you scroll down to the bottom of the page on MySQLi Overview offers it will you'll see a comparison table.

If you're interested in benchmarks, I came across a blog which you might want to take a look at Blog - ioMeWeekly

answered Jul 15 '13 at 15:14

Like many other "blog posts" this one can actually tell you nothing neither on the "speed difference" nor on the necessity of such a benchmark. – Your Common Sense Jul 15 '13 at 15:24
old mysql ext is okay with Prepared Statemments, Multiple Statements and Transactions. I can't believe so many people are dragging this rumor along – Your Common Sense Jul 15 '13 at 15:26
It provides the scripts enabling the reader to test themselves. It then answers the question 'Is it faster for me, in my environment?'. – Jul 15 '13 at 15:27
Sadly, you don't get the point. This test is essentially useless by intention and wrong by implementation. In any environment. – Your Common Sense Jul 15 '13 at 15:32
Using PDO extension it supports prepared statements etc however the standard MySQL extension does not. Referencing: http://www.php.net/manual/en/mysqlinfo.api.choosing.php – Jul 15 '13 at 15:34
PDO can emulate prepared statements. Mysql ext can do it as well. Referencing: own experience. – Your Common Sense Jul 15 '13 at 15:57

MySQL performance again MySQLi

2 Answers2