On Wed, Jul 23, 2008 at 2:01 AM, Sean Allen <[EMAIL PROTECTED]> wrote:
> i'm starting to do some serious playing around with zodb.
> step 1, move about 10% of our data over to get an idea about speed of
> searching 1.5 million entries etc.
> standard file storage... the csv file i dumped all the info to is about 190
> megs, the resulting file
> storage file is 750 megs ( 1.8 gigs before packing ). Does this mean, that I
> should expect the entire database
(After reading your other message about indexing); if you aren't doing
any indexing yet, then you should expect a larger database once the
indexes are added.
Some advocate keeping indexes in a separate database, especially if they
are a significant fraction of the total database size. That way you can
have different packing schedules, backup plans, storage devices, etc.
Senior Software Engineer
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org