[Phpgroupware-users] PHPGroupware optimization [mysql, ldap]

[Christian Rost]

Hi,

we're deploying PHPgw (0.9.16.006) with one of our customers. In its final
stage there will be about 250 users working with PHPgw.

At the beginning we've set up PHPgw with MySQL and OpenLDAP on the same server
and about 30 users are already working with PHPgw. PHPgw uses OpenLDAP based
Information for authentication, users/ group information and to store
addressbook data. So far, there are about 400 LDAP user entries, including
system and normal users and about 2500 contacts.

Everything is working fine, but we've discovered a significant performance
decrease when working with Infolog. There are 30 Infolog entries and it takes
about 20 secs to show them all. While surveying cpu usage with top, we
discovered that apache2 takes about 85%, slapd about 11%, mysql and other
daemons the rest.

To decrease the cpu usage of apache2, we installed turck-mmcache, with no
success. We've analyzed the LDAP queries but PHPgw is only searching for the
uid of the user who started the querry. All LDAP attributes PHPgw is searching
for are indexed.

Any comments are welcome,

Christian

--
==================================
Christian Rost
roCon - Informationstechnologie
Herner Strasse 299 B-29
44809 Bochum

fon: +49 (0) 234 33 80 820 - 0
fax: +49 (0) 234 33 80 820 - 9
url: http://www.rocon-it.de