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