Well there was a small improvement. The total sync time is down to about 40 minutes. Still too long though...
I have an idea, let me know if you think it will work. I can add a new column to the SQL table stating weather the entry needs to be "updated", "added" or "removed." How can I configure LSC to just check these entries that have one of these tags and update accordingly? This would solve my time issue since we wouldn't have any more than about 10 changes per day. Eliminating the need to query 100,000 entries each cycle. [TSGsign] Kyle Parrish Server Operations Engineer 352-674-1508 From: [email protected] [mailto:[email protected]] On Behalf Of Clément OUDOT Sent: Wednesday, September 30, 2015 8:25 AM To: [email protected] Subject: Re: [lsc-users] SQL to LDAP Sync takes several hours Le 30/09/2015 14:13, Parrish, Kyle a écrit : I had a feeling it was taking longer than it should. Our infrastructure is not a problem...it must be with the config. Can you take a peek at my config and let me know if there is anything I should optimize? I am basically taking a user ID and Pin number from SQL and importing that as a user in LDAP. I don't see anything to optimize in the configuration. You just need to set an index on ID in your database and on uid in your LDAP directory. Use the DEBUG loglevel in logback.xml to see which operations are done, you should be able to discover if the bottleneck comes from the database ou from the LDAP directory. I don't have any feedback on using LSC with SQLServer. -- 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
