Le 05/01/2017 à 15:45, Parrish, Kyle a écrit :
Hello,
We have recently implemented LSC to synchronize user accounts from a
SQL database to an OpenLDAP database.
Everything is working perfect except for the rather long time that it
takes to synchronize.
With roughly 105,000 accounts to sync it takes an average of 45
minutes to process the task. Even if there are only a handful of
changes (20) it will take the same amount of time.
How can this process be improved upon?
I have created indices on both the SQL database and the LDAP database.
Hello,
indeed, the number of changes has (almost) no impact as LSC will always
read all source and destination entries. I see no easy optimizations for
this, unless limiting the number of attributes you read in source and
destination. You can also try to split your task in several tasks by
playing with SQL and LDAP filters.
--
Clément OUDOT
Consultant en logiciels libres, Expert infrastructure et sécurité
Savoir-faire Linux
137 boulevard de Magenta - 75010 PARIS
Blog: http://sflx.ca/coudot
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
