Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:33154 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 40248 invoked by uid 1010); 15 Nov 2007 14:03:10 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 40232 invoked from network); 15 Nov 2007 14:03:10 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 15 Nov 2007 14:03:10 -0000 Authentication-Results: pb1.pair.com smtp.mail=brianm@dealnews.com; spf=pass; sender-id=pass Authentication-Results: pb1.pair.com header.from=brianm@dealnews.com; sender-id=pass Received-SPF: pass (pb1.pair.com: domain dealnews.com designates 129.41.69.185 as permitted sender) X-PHP-List-Original-Sender: brianm@dealnews.com X-Host-Fingerprint: 129.41.69.185 smtp.dealnews.com Linux 2.5 (sometimes 2.4) (4) Received: from [129.41.69.185] ([129.41.69.185:38827] helo=smtp.dealnews.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 25/66-28167-3915C374 for ; Thu, 15 Nov 2007 09:03:01 -0500 Received: (qmail 30285 invoked from network); 15 Nov 2007 14:02:55 -0000 Received: from unknown (HELO mail.dealnews.com) (10.1.1.7) by -H with ESMTPS (DHE-RSA-AES256-SHA encrypted); 15 Nov 2007 14:02:55 -0000 Received: (qmail 32375 invoked from network); 15 Nov 2007 14:02:55 -0000 Received: from h125.23.91.75.ip.alltel.net (HELO macdough.local) (brianm@75.91.23.125) by -H with ESMTPA; 15 Nov 2007 14:02:55 -0000 Message-ID: <473C5188.9080409@dealnews.com> Date: Thu, 15 Nov 2007 08:02:48 -0600 User-Agent: Thunderbird 2.0.0.6 (Macintosh/20070728) MIME-Version: 1.0 To: Andrew Mason , internals@lists.php.net References: <99cd336d0711142233l7ecb3e17hecfc735f6d370958@mail.gmail.com> In-Reply-To: <99cd336d0711142233l7ecb3e17hecfc735f6d370958@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] PDO performance From: brianm@dealnews.com (Brian Moon) Andrew Mason wrote: > 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 > I have not done the benchmark recently, but here is what I found last year. It just depends on what is important to you. http://dealnews.com/developers/php-mysql.html -- Brian Moon Senior Developer ------------------------------ http://dealnews.com/ It's good to be cheap =)