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

[Chris Weiss]

i wonder how much of this is due to php doing extra work because mysql
doens't support subselects.  And because infolog isn't joining the
tables directly but calling the bo objects of the different apps,
which is the future proof way but far from optimized.

With the current DB model (lowest common featureset) I don't know how
easy this would be to fix.  You'd first have to upgrade to mysql 4.1+
or postgresql then rewrite the infolog functions, and maybe cal and
addressbook too, so that proper subselects and joins could be used to
make the db do the work it is better at.


On 10/28/05, Christian Rost <address@hidden> 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
>
>