Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:33148
Return-Path: <slackmase2@gmail.com>
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Delivered-To: mailing list internals@lists.php.net
Received: (qmail 79678 invoked by uid 1010); 15 Nov 2007 06:33:05 -0000
Delivered-To: ezmlm-scan-internals@lists.php.net
Delivered-To: ezmlm-internals@lists.php.net
Received: (qmail 79663 invoked from network); 15 Nov 2007 06:33:05 -0000
Received: from unknown (HELO lists.php.net) (127.0.0.1)
  by localhost with SMTP; 15 Nov 2007 06:33:05 -0000
Authentication-Results: pb1.pair.com smtp.mail=slackmase2@gmail.com; spf=pass; sender-id=pass
Authentication-Results: pb1.pair.com header.from=slackmase2@gmail.com; sender-id=pass; domainkeys=bad
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 64.233.184.235 as permitted sender)
DomainKey-Status: bad
X-DomainKeys: Ecelerity dk_validate implementing draft-delany-domainkeys-base-01
X-PHP-List-Original-Sender: slackmase2@gmail.com
X-Host-Fingerprint: 64.233.184.235 wr-out-0506.google.com Linux 2.4/2.6
Received: from [64.233.184.235] ([64.233.184.235:3135] helo=wr-out-0506.google.com)
	by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP
	id 2B/F2-46940-128EB374 for <internals@lists.php.net>; Thu, 15 Nov 2007 01:33:05 -0500
Received: by wr-out-0506.google.com with SMTP id 58so510143wri
        for <internals@lists.php.net>; Wed, 14 Nov 2007 22:33:03 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        bh=XhIq8mQmijzFh8r9FTmgyAP/ETUJX8ovarRrUPEkIwI=;
        b=McNLk99LsvBDe3XDLX0oy3CDQ8DXMvbVDoi2BBnpgseHmTWLNZN52drEUkVbtZGXnbUkB/tCbfZPDZMhZqcL2ml2V79uW6r/UAUdBKFs04xizS0tEr9Oq8AIHxuOTJCUuH1WqkUpjn7tdGSY2fB0hrRhi1lrGYG6P/EJGDExvmU=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
        b=qa8e2hSnESl5Igo0J5l59yMuwujyhOuCNeCdBgqi4PyyTJx+iXsTku5aTwJQjtwGu65HPPP5y9mJhfm3CPWvO4bViTjshv0fpyo2Hnc1w+iq3o0PaDtCSe3SFGzuBWVYAmpwCyU3ynVLyQ+PyREd4ViHnIln8jjAhLrp52NkENQ=
Received: by 10.70.11.5 with SMTP id 5mr621577wxk.1195108382476;
        Wed, 14 Nov 2007 22:33:02 -0800 (PST)
Received: by 10.70.33.12 with HTTP; Wed, 14 Nov 2007 22:33:02 -0800 (PST)
Message-ID: <99cd336d0711142233l7ecb3e17hecfc735f6d370958@mail.gmail.com>
Date: Thu, 15 Nov 2007 17:03:02 +1030
To: internals@lists.php.net
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Subject: PDO performance
From: slackmase2@gmail.com ("Andrew Mason")

Hi guys,
Just a quick question. I've recently been looking  at changing over
our code to use the PDO interface to a mysql database.

Currently we are using MySQLi but after looking at the PDO interface i
personally prefer the way API is presented (not saying mysqli is bad
or  anything like that...completely personal). I was just wondering if
there was any performance or latency hit by using PDO with mysql 5.

From what i have benchmarked there isn't any at all, but since PDO
came back faster for a few things i'm not sure how accurate my
benchmarks were =)

Just looking for some feedback.

many thanks
Andrew