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. http://www.colliberty.com/ +33 661 58 14 64 _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org http://mail.zope.org/mailman/listinfo/zodb-dev