Wez Furlong

Browse archives
Conference Presentations
Subscribe. (circulation 746)
Comments. (circulation 2)

Search powered by Google

I am Wez Furlong, Director of Engineering at Message Systems. My team is responsible for the fastest MTA on Earth.

I'm also a PHP Core developer and OpenSource contributor, residing in Maryland with Juliette, Xander and Lily. (read more)

24th August 2006 @ 15:38 EDT

I was just skimming over Santos' Post about SDO, and was saddened to see more anecdotes and less facts.

Here are two points that you should take note of:

I'd love to see someone run some fair comparisons and publish the numbers.

Post a comment
24th August 2006 @ 19:45 EDT

Why not do them yourself? Or if you have done them, then I'll look over your posts to see if you have posted speed results.

I'm sorry, once "better" speed comparisons come out then I'll be less likely to say that PDO is slow. If I did them, then it would be primitive with simple microtime, which wouldn't exactly be accurate or fair.

I don't think my post or possible speed decreases are going to keep people away from PDO.

My post was simply trying to state that what SDO currently offers has been widely covered in PHP. That it is going to take time before it is widely used. Finally, that developers would be more inclined to use PDO over SDO for their applications.

As a final note, I have to use what information is available and the benchmarks is a good one, so I used it. While I do know about the emulate prepared statements, it seems kind of foolish that one would have to use that. If it is faster and better, then why even have native prepared statements?

by Santosj in .
24th August 2006 @ 20:05 EDT

Why have prepared statements if they're sub-optimal? Ask the folks at MySQL. They'll get better one day, I'm sure, but they're apparently not quite up for prime-time just yet.

The point I was trying to make was that, rather than relying on one other persons (possibly flawed) benchmarks to form and spread the opinion that "PDO is slow", you should measure the performance for yourself, for the kinds of things that you're doing.

Your comments here imply that you haven't done any benchmarking for yourself, or that you haven't tried very hard to find existing benchmarks. IMO, it's better to come out and say that up-front and point people at the source of your information when you blog, otherwise you are building up a web of misinformation, and it is that that I'm objecting to.

Why haven't I done benchmarking? I think I'm doing enough for PHP in the time I can find for it right now. There's only one me, but there are plenty of people out there, like you, that could build up excellent blog content by sitting down and putting a bit of effort into it.

+1 for factual rather than anecdotal content.

24th August 2006 @ 20:27 EDT

I'm sorry if I always appear to come off as "PDO is bad, don't use it," because I have a lot of admiration for what PDO allows developers to do. I should write a post about why I do enjoy PDO, but I haven't really gotten around to it.

I don't think about writing about stuff that I appreciate. The only reason I wrote about SDO was because I have heard so much discussion about SDO but no one really stated that the features are already offered in PHP.

Actually, for me personally, using PDO was an considerable speed increase over my own object database access abstraction layer. Which is to only prove how much of a n00b I am, but oh well. I did write about that or a snippet of it at least.

I would say that going from about 1.5 seconds to .5 seconds was considerable increase. Site now preforms at .1 seconds, but I'm not going to spend the time to make it any faster.

Oh, I also removed the section about the direct access, the entire paragraph really wasn't I wanted to say. I also added in your points to not totally put hate on about PDO.

by SantosJ in .
24th August 2006 @ 20:36 EDT

The original title was "Opinion: Why SDO Doesn't Take Off", but I removed the "Opinion".

by SantosJ in .
25th August 2006 @ 00:00 EDT

While PDO cannot compete in speed against the mySQL extension with a bit of setting tweaking in pdo_mysql it is possible to make it quite a bit faster then mysqli. In fact when properly tweaked it is only 5-6% slower then ext/mysql/. And in some cases it is possible to make it match in speed (instances where shortcut functions such as fetchColumn() and alike are being used).

by Ilia Alshnetsky in .
Post a comment