Le 29/09/2015 22:17, Parrish, Kyle a écrit :
The initial sync completed at about 1.5 hours and it looks like the subsequent
syncs also take about that long. This seems really long to simply check if an
item has been updated.
Also, this process seems to put a lot of work on SQL server with as many
queries as it sends.
I am not sure what to compare this to. Is this normal behavior?
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Clément OUDOT
Sent: Tuesday, September 29, 2015 3:53 AM
To: [email protected]
Subject: Re: [lsc-users] SQL to LDAP Sync takes several hours
Le 29/09/2015 09:09, Natan Sanson a écrit :
Hello Parrish, did you try to put some indexes on DB and on the fields
used on your LDAP server? This can change a lot your performaces
Indeed, you should see why the requests are taking so much time. Using indexes
and optimizing requests is the good approach.
Hello Kyle,
please answer to the list.
First, you should take a look at
http://lsc-project.org/wiki/documentation/latest/basics to understand
how LSC works and why it does all these requests on your database. Then
you can get more logs if you edit logback.xml file and set a DEBUG loglevel.
--
Clément OUDOT
Consultant en logiciels libres, Expert infrastructure et sécurité
Savoir-faire Linux
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
