LDAP result iteration performance problem.

[Vicki Amin]

Hi Ranchers,

I am running the below code to retrieve some results from an LDAP server and iterate through them. The problem is that the LDAP query itself takes just 0.25 seconds but the iteration is taking around 9 seconds. Any clue as to what I might be doing wrong over here?

Vector vector=new Vector();
Attributes match = new BasicAttributes();
match.put(new BasicAttribute("uid"));
String[] IDs = {"ou", "o"};
 		 
SearchControls constraints = new SearchControls();
try
{
	/* get the intial context */
         ctx = getInitialContext(); 
         
         /* set the search filters and scope */
         MY_FILTER = "<some filter>";
  	 constraints.setSearchScope(SearchControls.SUBTREE_SCOPE);
         constraints.setReturningAttributes(IDs);         
	
	 /* Execute the search - takes 0.25 seconds*/
	 long startQuery=System.currentTimeMillis();
         NamingEnumeration results = ctx.search(MY_SEARCHBASE, MY_FILTER, constraints);
         long endQuery=System.currentTimeMillis();
         System.out.println("Time spent for iteration -> "+(endQuery-startQuery));
        
          /* Iterate through the results - takes 9 seconds */
         long startIteration = System.currentTimeMillis();
         while(results.hasMoreElements())
         {         	
		results.nextElement();
       	 }     
       	 long endIteration = System.currentTimeMillis();
       	 System.out.println("Time spent for iteration -> "+(endIteration-startIteration));
       	 
}
catch(NamingException e)
{
       	e.printStackTrace();
} 

Regards,
Vicki.

[steve souza]

How many elements does it iterate. It may be that although the initial query returns quickly each time you iterate the data it has to do a roundtrip to the source. If so, you may be able to set a buffer size or some other connection parameter that can reduce the roundtrips.

[Vicki Amin]

Hi Steve,

Thanks for the prompt reply. That actually makes a lot of sense. Would you know of any connection param's that I can use to reduce the round trips? One more question; would doing a simple

 results.nextElement();    

also involve a round trip to the server?

Regards,
Vicki.

[steve souza]

I would look at the LDAP api you are using. I'm not familiar with it. In jdbc you can set such parameters on connection. Look at the initial context to see if you can pass it parameters on creation.