[Owncloud] Heavy LDAP user search

[Arthur Schiwon]

On Thursday, September 20, 2012 11:15:54 AM Arthur Schiwon wrote:
> On Wednesday, September 19, 2012 04:32:11 PM Manuel Delgado wrote:
> > I made the tests with my changes and your patches. It's simply miraculous:
> > $ time php /srv/sites/owncloud/cron.php
> > 
> > My changes:
> > real    235m2.634s
> > user    229m51.470s
> > sys    0m14.533s
> > 
> > Patch A (prepared statement)
> > real    3m3.474s
> > user    0m12.065s
> > sys    0m12.689s
> > 
> > Patch B ($arr[$dn])
> > real    3m36.445s
> > user    0m16.833s
> > sys    0m12.661s
> > 
> > The idea of the prepared statement and the unidimensional array worked
> > perfectly. I will be doing more test and reports if found something, but
> > it's working great with 110k ldap users.
> 
> Wow, did not expect it to be that huge difference!
> I tend to implement then the option using prepared statements, however I
> wait for your conclucsion after the other tests.

I already pushed an (further slightly improved) version of the prep-statements 
based solution to master. Feedback welcome.

Cheers
Arthur

> 
> > Thanks a lot!
> 
> Thank you for finding the bottleneck :)
> 
> Cheers
> Arthur
> 
> > Manuel Delgado
> > 
> > -----------------------------------------------------------
> > *Usuario Linux* *#520940 <http://counter.li.org/>*
> > 
> > Bach. Computación e Informática
> > Universidad de Costa Rica
> 
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud