Jon... we are implementing an enterprise sized webmail system for a client (3000+ users) on ACSclassic 4.2 . As part of our testing we added (this far) 580 users, at which point everything ground to a halt as described by this thread.
We were excited to find, and implement your bugfix ...from /web/openacs-4/packages/acs-kernel/sql/oracle from the nightly-2001-07-03.tar.tgz
<<acs-permissions-create.sql>>
Unfortunately this has not helped , and each attempt to open mailboxes causes the subsequent calls to permission_p which result in VERY dismal performance.
I read that your environment became very usable after the bugfix... do you have any suggestions as to why we dont see the same improvement ?
we are running RH 6.2 with Oracle 8.1.7 on a PIII 700 with 1G Ram
with 580 registered users, it takes roughly 10 to 15 seconds per page request... regardless of which page, or module...
Thanks in advance