Active Directory: Query catalogue

Begin development to enumerate all active users from ERGON's AD to a web front end. ERGON's AD contains nearly 7000 records in the CN - SOE users. This proved extremely slow using DirectoryServices. To enumerate the entire list took 1min10secs. Noticed that if you return 1000 records it took approx 3 seconds. The delay grows exponentially as the number of records increases.

Have discussed this finding with Alton. Proposed we create a subset of the data in AD for users and replicate this to a SQL database to speed up information retrieval. Alton agrees and further suggests he will look into ways of creating a trigger which updates SQL whenever AD is updated.

Spoke to Paul James. Currently the only Energex's GC contains both Ergon and Energex user details. This will eventually needs to be shifted to the SPARQ domain as it makes little sense to keep Ergon users in the Energex's domain. Spoke to Alton about this as well.

*Update*
Changed value for pagesize in directorysearcher. This increased the speed with which data was retrieve from AD. 7000 records are now returned in 4 secs. This is still slow and we will look into the SQL option.