note 102711 rejected from mysqli.query by danbrown

[email protected]
Newsgroups php.notes
Message-ID <[email protected]>
Note Submitter: justin at stickypages dot ca 

----

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???
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.