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