See, I'm doing the opposite. I'm getting a list of accounts from a SQL database and trying to then perform a read query to get those user accounts from AD. However, I can't find an elegant way to do that in 1 query so I'm looping over my results and doing individual queries to the AD for each account. I'm definitely looking into this AD/SQL linking which I had never heard of before. Thanks for the help!
John -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 10:27 AM To: cf-talk Subject: RE: LDAP Query Performance question My current process is to query AD using CFLDAP. That returns about 5,500 user objects. Then, I loop over those results and perform a CFQUERY to a SQL 2005 database. Our SQL server is pretty beefy, so we haven't had any performance issues. My goal of this process is to compare names, titles, phones, addresses, etc, from AD to the daily-updated information in SQL. If any one of the data attributes is different, then I perform an LDAP update to refresh that particular user object. It does take a few minutes to run, however, I have found a faster method of connecting AD directly to SQL Server. When I get some time, I'm going to rewrite this process to actually join AD and the SQL table and compare the data in one swoop rather than thousands of swoops. Then, I will be able to schedule this as a SQL job and take the full load of of ColdFusion. Until then, it doesn't hurt a thing. Mike -----Original Message----- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 9:19 AM To: cf-talk Subject: RE: LDAP Query Performance question Mike- When you do this is this a loop that runs 5500 queries or 1 query that updates 5500 records? Just curious what the impact is for each connection. John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4