Why NOT use fetchReturnsList?

"Leo Leo" <[email protected]> Thu, 17 Jun 2004 16:46:56 +0200 (MEST)
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
Hello!

I have still a question about this parameter "fetchReturnsList".

As far as I have understood it, the pgResultSet contains a lot more
information about the retrieved data, than the result by Lists.

But: 
Isn't this additional information equal for ALL selected rows?. If I have
for example 1.000 selected rows, I will have 1.000 times the additional info
for EACH column and EACH Row, but I would need this information only once
per SELECT (except UNION-Statements).

So, shouldn't it be better (Performance, less traffic etc.) to gather this
additional information in an other way (just once per select) and get the
data by lists? (I made something like this for PHP some months ago)

What is your opinion about that?

Thanks Leo

-- 
+++ Jetzt WLAN-Router für alle DSL-Einsteiger und Wechsler +++
GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl



-------------------------------------------------------
This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND