[phpldapadmin] [ phpldapadmin-Bugs-3391046 ] Loading entries with many attributes is very slow

Bugs item #3391046, was opened at 2011-08-13 13:36
Message generated for change (Comment added) made by athompso
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=498546&aid=3391046&group_id=61828

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Pending
Resolution: None
Priority: 5
Private: No
Submitted By: Roland Gruber (gruberroland)
Assigned to: Nobody/Anonymous (nobody)
Summary: Loading entries with many attributes is very slow

Initial Comment:
Hi Deon,

opening an LDAP entry that has lots of attributes (about 100) takes about 10 seconds on a recent PC. The problem is the sorting.
PLA calls Attribute->getName() and real_attr_name() several 100,000 times. This is caused by ~100,000 calls of getFriendlyName().

The source seems to be in sortAttrs($a,$b) that does not use cached values. Probably, it would be even better to simply get a list of all attribute friendly names first and then do a simple sorting on them (and no usort at all).

Unfortunately, I do not know enough about the code to provide a patch. I hope that my explanations help you to fix this.


Best regards

Roland

----------------------------------------------------------------------

Comment By: Adam Thompson (athompso)
Date: 2011-09-08 10:21

Message:
I don't have as extreme a case as Roland, but I've also noticed this.  Not
the # of LDAP entries in a container, but the number of distinct key/value
pairs (attributes) on a single LDAP entry makes opening that specific DN
quite slow.  My server is sometimes CPU-starved, and I can see the
difference between a DN with ~20 attrs and ~100 attrs at that time.

----------------------------------------------------------------------

Comment By: Deon George (wurley)
Date: 2011-09-08 07:45

Message:
Hi Roland,

I'm not sure I follow you? On my test server (the demo site), I have a few
branches with 1000+ entries, and it takes about 3 seconds for me (to expand
a branch on the tree)... Is this the scenario you are talking about?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=498546&aid=3391046&group_id=61828

------------------------------------------------------------------------------
Doing More with Less: The Next Generation Virtual Desktop 
What are the key obstacles that have prevented many mid-market businesses
from deploying virtual desktops?   How do next-generation virtual desktops
provide companies an easier-to-deploy, easier-to-manage and more affordable
virtual desktop model.http://www.accelacomm.com/jaw/sfnl/114/51426474/
______________________________________
phpLDAPadmin development mailing list.
To unsbuscribe: https://lists.sourceforge.net/lists/listinfo/phpldapadmin-devel
http://phpldapadmin.sourceforge.net/