[Zope] ZODB vs SQL

Derek Basch dbasch@yahoo.com
Fri, 10 May 2002 18:37:28 -0700 (PDT)


How about for large amounts (500,000?) of small
records that never change after they are created? 

Thanks,
Derek Basch

--- Ed Colmar <ed@greengraphics.net> wrote:
> On Fri, 10 May 2002, Derek Basch wrote:
> 
> > Speaking of which, can anyone tell me the
> practical
> > size limit of the ZODB? For example, could 100,000
> > small documents be stored and indexed/searched
> without
> > much trouble? How many records could I store using
> the
> > BTree package? Is an SQL back-end my best choice
> for
> > large amounts of small records?
> 
> Hi Derek
> 
> the ZODB is best suited for objects that don't
> change very freuqenctly, or 
> that you need to be able to undo.
> 
> For small records that are changing, SQL is by far
> the best way to go.
> 
> -ed-
> 
> -- 
> Green Graphics   :::   Print and Web Design   :::  
> 510.923.0000 
> 


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com