[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