[Phpgroupware-tracker] [Bug #1142] Ldap query very very slow

[nobody]

=================== BUG #1142: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1142&group_id=509

Changes by: Anonymous user        Date: Thu 03/27/03 at 05:56

------------------ Additional Follow-up Comments ----------------------------
I notice that version 0.9.14.002 doesn' t include the patch to see "only yours"



=================== BUG #1142: FULL BUG SNAPSHOT ===================


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Fri 09/06/02 at 04:11
Category:  addressbook                Bug Group:  0.9.14 release            
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  lkneschke               
Status:  Open                         Component Version:  None              
Platform Version:  Solaris            Reproducibility:  None                

Summary:  Ldap query very very slow

Original Submission:  If I get the entire list of contact stored in an LDAP 
base I need to wait at least 40 seconds before I can see them. I have 500 
contacts in the base.
I cannot see only my contact because when I select "only yours" I get back an 
empty page (why??)
During the query the http daemon consume all cpu and after the results are 
displayed the cpu usage descrease very slow.
I' m using apache-1.3.26 + php 4.1.2 + openldap 2.0.23
In attach a trace of the apache daemon during all life of the query.In line 
2529 you can see 37 second of nothing and in line 2767 other 15 seconds...
The ldap daemon as no interesting activities.
N.B. This behaviour is non visible when I edit one contact or when I search the 
entire base for one contact

Follow-up Comments
*******************

-------------------------------------------------------
Date: Thu 03/27/03 at 05:56         By: None
I notice that version 0.9.14.002 doesn' t include the patch to see "only yours"

-------------------------------------------------------
Date: Wed 01/29/03 at 10:31         By: beoe
I submitted a patch, that corrects the wrong behaviour of showing the empty 
page when you select "only yours" (check 
http://savannah.gnu.org/patch/index.php?func=detailpatch&patch_id=1024&group_id=509).
 

But I do have the same problem concerning performance:
400 Entries from different users, query takes about 10 secs. If I do submit the 
query using ldapsearch -x "(.......)" it takes 2 secs. Any ideas?


CC list is empty


File Attachments
****************

-------------------------------------------------------
Date: Fri 09/06/02 at 04:11  Name: 15159.truss.bz2  Size: 18KB   By: None
Trace of http daemon
http://savannah.gnu.org/bugs/download.php?group_id=509&bug_id=1142&bug_file_id=79


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1142&group_id=509