X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FA7AD7684 for ; Sun, 21 Aug 2005 22:25:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31834-09 for ; Mon, 22 Aug 2005 01:25:53 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CCAF4D6D99 for ; Sun, 21 Aug 2005 22:25:52 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7M1Pujh005496; Sun, 21 Aug 2005 21:25:56 -0400 (EDT) To: "Greg Sabino Mullane" Cc: pgsql-interfaces@postgresql.org Subject: Re: DBD::Pg performance bites compared to DBD::mysql? In-reply-to: References: Comments: In-reply-to "Greg Sabino Mullane" message dated "Mon, 22 Aug 2005 00:20:00 -0000" Date: Sun, 21 Aug 2005 21:25:56 -0400 Message-ID: <5495.1124673956@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/36 X-Sequence-Number: 5707 "Greg Sabino Mullane" writes: > I can't imagine that it was causing a factor of 2 difference, but I've > changed the code in DBD::Pg to make do() a lot smarter, for brain-dead > benchmarks such as MySQL's that use do() instead of prepare/execute > like they should. In short, DBD::Pg will short-circuit a lot of the usual > work and call PQexec directly if it can get away with it, which should > make the profile Tom posted look a lot better. It also avoids overhead of > going through Pg.pm, and is all C/XS code now. Hopefully, this should > make the benchmarking results a little more fair. :) This is now in > cvs, and will be part of the upcoming version 1.44 of DBD::Pg. Cool. Thanks for doing that. Do you have an idea when 1.44 will be out? regards, tom lane