X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 45D1A52966 for ; Fri, 8 Apr 2005 23:17:32 +0100 (BST) 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 58242-05 for ; Fri, 8 Apr 2005 22:17:25 +0000 (GMT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id 41CBE535EE for ; Fri, 8 Apr 2005 23:17:24 +0100 (BST) Received: (qmail 14612 invoked from network); 8 Apr 2005 22:17:26 -0000 Received: from unknown (HELO localhost) (207.228.252.42) by 0 with SMTP; 8 Apr 2005 22:17:26 -0000 From: "Greg Sabino Mullane" To: dbdpg-general@gborg.postgresql.org Cc: pgsql-interfaces@postgresql.org Cc: pgsql-interfaces@postgresql.org Subject: Re: [Dbdpg-general] benchmarking old Pg and DBD::Pg X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: Date: Fri, 8 Apr 2005 22:17:26 -0000 X-Mailer: JoyMail 1.48 Message-ID: <7faf5fa48d5bef0dbd507740522747bf@biglumber.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.156 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/40 X-Sequence-Number: 5456 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Let's slow down and back up a bit. First, what version of PostgreSQL are you using to compile DBD::Pg, and what version are you connecting to? Many of the things being discussed have already been solved if you are running a modern version of PG (e.g. 7.4 or greater). The binding is already handled quite well: we use PQprepare whenever possible. The default of type "VARCHAROID" is mostly cosmetic, so that some other things work: we actually send a type "unknown" (0) if no type is specified for a placeholder via bind_param. (see the "defaultval" of the placeholder struct). Older servers may benefit from the VARCHAROID change however, so I will see about making that change. The stuff in types.c could certainly use some cleaning up, but it is also not really used anymore - we let the server do all the quoting for us now via PQexecPrepared and PQexecParams. - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200504081815 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFCVwLNvJuQZxSWSsgRAtmwAKC4e2bPApAYXj7cz2M2fOwtmPEk1ACgzz9C AqwZr6PYj+/sUmomA7dKlqE= =MdcS -----END PGP SIGNATURE-----