[ZODB-Dev] Re: ZODB Benchmarks

[Lennart Regebro]

On Tue, Mar 4, 2008 at 9:27 PM, Shane Hathaway <shane at hathawaymix.org> wrote:
>  - Did you use optimal methods of insertion in Postgres, such as COPY?
>  Also note that a standard way to insert a lot of data into a relational
>  database is to temporarily drop indexes and re-create them after
>  insertion.  Your original test may be more valid than you thought.
>
>  - 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. :)

-- 
Lennart Regebro: Zope and Plone consulting.
http://www.colliberty.com/
+33 661 58 14 64