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