On Tue, Mar 4, 2008 at 9:27 PM, Shane Hathaway <[EMAIL PROTECTED]> 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.
+33 661 58 14 64
For more information about ZODB, see the ZODB Wiki:

ZODB-Dev mailing list  -  ZODB-Dev@zope.org

Reply via email to