[ZODB-Dev] Re: ZODB Benchmarks

[Shane Hathaway]

Lennart Regebro wrote:
> On Tue, Mar 4, 2008 at 9:27 PM, Shane Hathaway <shane at hathawaymix.org> wrote:
>>  - Did you use optimal methods of retrieval in Postgres?  It is
>>  frequently not necessary to pull the data into the application.  Copying
>>  to another table could be faster than fetching rows.
> 
> But is that relevant in this case? Retrieval must reasonably really
> retrieve the data, not just move it around. :)

Not if you're only retrieving intermediate information.  When you write 
an application against a relational database, a lot of the intermediate 
information does not need to be exposed to Python, helping performance 
significantly.

Shane