[Zope-dev] ZCatalog fast as admin, dog slow as anonymous and other users

[Jason Spisak]

Zopistas,

My ZCatalog is fast as admin, but dog slow as anonymous and other users. 
  Anyone had this same experience?  Details:

marjors:

Zope 2.6.2
CMF 1.3
Plone 1.0.5

about 50,000 cataloged objects  (dual xenon server, plenty of ram, RAID)

User folder has 15k users in it, but admin is one of those users.

i've factored it way down and a simple search with just 1 Event loaded, 
like:

return context.portal_catalog(Type='Event')

is instantaneous for the 'admin' user, but takes about 10 seconds to 
return 1 SINGLE object.  (only 1 Event loaded)  imagine the time it 
takes to search and display 1300 events (which is what's normally in 
there).  ouch.  i've rebuilt the indexes, and still no dice.

Any help would be greatly appreciated.

All my best,

Jason Spisak