On 28.11.2008 12:56 Uhr, Chris Withers wrote:
Andreas Jung wrote:
There is a difference pulling 500k brains out-of-the catalog compared
to traversing a ZODB with 500k object. I assume that the catalog
solution is slightly faster :)

Yes, well, you kno what they say about assumptions...

ok, you want the hard facts :-)

CMF Site with subfolder containing 87k objects:

Obtaining the brains from the catalog: 25 seconds (uncached, basically only ZODB load operations)
Same with the ZCatalog within the ZODB cache: <1 milli second

Using ZopeFind: I stopped after 10 minutes...

ANdreas
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[EMAIL PROTECTED]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard

_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to