Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C54B5475AE6 for ; Tue, 14 Jan 2003 04:12:36 -0500 (EST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by postgresql.org (Postfix) with ESMTP id 0E65947580B for ; Tue, 14 Jan 2003 04:12:36 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030114091237.MGAF26808.lakemtao03.cox.net@[192.168.1.1]> for ; Tue, 14 Jan 2003 04:12:37 -0500 Subject: Re: Cursor rowcount From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <12895.1042517980@sss.pgh.pa.us> References: <49456.216.80.95.13.1042493599.squirrel@www.l-i-e.com> <6429.1042496530@sss.pgh.pa.us> <50156.216.80.95.13.1042506350.squirrel@www.l-i-e.com> <12895.1042517980@sss.pgh.pa.us> Content-Type: text/plain Organization: Message-Id: <1042535548.27702.31.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 14 Jan 2003 03:12:28 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/81 X-Sequence-Number: 728 On Mon, 2003-01-13 at 22:19, Tom Lane wrote: > writes: > > Yes, but as noted in my longer version, that number does not seem to "come > > through" the PHP API. > > Perhaps not, but you'd have to ask the PHP folk about it. This question > surely doesn't belong on pgsql-performance ... Wellllll, maybe it does, since the /performance/ of a SELECT COUNT(*) followed by a cursor certainly is lower than getting the count from a system variable. But still I agree, the PHP list seems more appropriate... -- +------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "Basically, I got on the plane with a bomb. Basically, I | | tried to ignite it. Basically, yeah, I intended to damage | | the plane." | | RICHARD REID, who tried to blow up American Airlines | | Flight 63 | +------------------------------------------------------------+