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

[Dave Hall]

Hi Christian,

I know that calnedar had some real performance issues with ldap.  I
fixed that ins stable cvs a month or so ago.  The fix only works if
using the popup selector.

Maybe this will help you.

Cheers

Dave

On Fri, 2005-10-28 at 14:01 +0000, Christian Rost wrote:
> 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
> 
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-users
-- 
Dave Hall (aka skwashd)
API Coordinator
phpGroupWare
e address@hidden
w phpgroupware.org