[Zope] RE: [Zope-CMF] mysqlUserFolder and CMF

Shane Hathaway shane@digicool.com
Tue, 24 Apr 2001 10:58:01 -0400 (EDT)


On Tue, 24 Apr 2001, Norman Khine wrote:

> Can you tell me though is there a particular reason as to the pro's & con's
> of using either existing acl_users or any other flavours of Login Managers.
>
> The reason why I am using the mysqlUserFolder is to integrated with the
> existing application and also because I did not want to clutter the ZODB
> with demographic user data. What I am getting at will I loose any
> performence if using one method or the other? I know you said you don't have
> any experience of using mysqlUserFolder, but maybe from a perspective of OO
> to RDBMS authentication.

Assuming mysqlUserFolder caches the authentication tokens (and it very
likely does), there should be only a minor performance drop when using an
RDBMS.  The ZODB has built-in caching that reduces the time it takes to
access authentication tokens to something on the order of nanoseconds :-)
while SQL authentication without caching can easily take up to 100 ms per
request, which would be noticeable.

> Also are there any methods which I can use to analyse the Log files from the
> CMF if they are any? If so where can I find them. Or is there a way in which
> I can query the Members folder, so that I can for example get total number
> of Members, their e-mails etc etc?

You could analyze the HTTP log, Z2.log.  To query the members folder use a
Python script like:

return len(container.Members.objectIds())

For email properties look at what the "roster" method does.

Shane