[Zope] ZCatalog and LoginManager - be aware.

[Oliver Bleutgen]

> Oliver Bleutgen wrote:
>> I fiddled around somewhat and discovered that disabling
>> subtransactions in ZCatalog does help (required for using
>> ZSQL Methods and ZCatalog in the same transaction).

> Yeah, that sux.  I think this is a known limitation.  I'm not sure.

It is, unfortunately this is only mentioned under "status" in
the ZCatalog interface. Well, I just got there by chance after 
several hours of digging around. I first thought perhaps some
DTML-Document was "bad-behaving". (not that I had an idea how
it might do that.)
With a (assumed) growing attractiveness of things like sql-based
UserFolders, perhaps a big warning sign either on the main page
of these products or ZCatalog (better IMO, since this is a default
product) would be in order, I guess. Or perhaps disabling 
subtransactions by default.
All in all this combination seems not uncommon.

>> Now I use SQL-based LoginManager, but why on earth did it only
>> fail on DTML-Documents? Is it because I have much more of them so
>> only then ZCatalog's subtransactions come into play?

> Probably because sub transactions are only commited after a certain
> number of words or values are indexed, and your DTML documents were the
> only things that held words.


> -Michel

cheers,
oliver