I have read through the documentation and understand how LSC works I just want to know if it is normal behavior for a sync of 100,000 entries to take 1.5+ hours with or without changes.
Sent by Outlook<http://taps.io/outlookmobile> for Android On Wed, Sep 30, 2015 at 12:56 AM -0700, "Clément OUDOT" <[email protected]<mailto:[email protected]>> wrote: 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
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
