[Owncloud] Heavy LDAP user search

Arthur Schiwon blizzz at owncloud.com
Thu Sep 20 09:15:54 UTC 2012


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.

> 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



More information about the Owncloud mailing list