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 _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
