[ZODB-Dev] Re: ZODB Benchmarks
Lennart Regebro
regebro at gmail.com
Tue Mar 4 15:36:18 EST 2008
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
More information about the ZODB-Dev
mailing list