News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brian Moon's Blog:
PDO Turbo Button
August 25, 2006 @ 08:09:32

On the "Ramblings of a web guy" blog by Brian Moon, there's a good look at some benchmarks run with PDO, normally versus with the "turbo button" as talked about by Wez.

So, a while back, I did some tests with the mysql, mysqli and PDO extensions. In those tests, I found PDO to be much slower for selects than mysql and mysqli. Half as slow in fact.

So, I decided to try Wez's trick of emulating prepared statements to see how PDO did. The results were interesting. Not sure if these are the "fair comparisons" that Wez wants to see, but I gave it my best shot.

His first set of stats was pretty close to his originals back when he first tested, and the second set of tests (with the "button" on) seem to be a bit hit and miss on the performance upgrade using this method.

I ran this several times. Maybe Wez or someone that works on PDO can shed some light on this. Seems like it would be tough to keep track of when to use this flag and when not to.
0 comments voice your opinion now!
pdo turbo button speed benchmark test prepared statement pdo turbo button speed benchmark test prepared statement


blog comments powered by Disqus

Similar Posts

DevShed: Unit Testing in Detail

Paul Jones' Blog: Labor Day Benchmarks

Wez Furlong\'s Blog: Using PDO MySQL?

SitePoint PHP Blog: PHP Dependency Injection Container Performance Benchmarks

Rubayeet Islam's Blog: MySQL Prepared Statements and PHP : A small experiment


Community Events





Don't see your event here?
Let us know!


series voicesoftheelephpant introduction laravel list language release opinion framework interview community bugfix api library deployment install podcast package tips symfony

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework