Using IBM Quickr with Sun Directory Server
A customer was testing out Lotus/IBM’s Quickr collaboration software and using Sun’s Directory Server as the user store. One of the system admins mentioned that queries searching for people were glacially slow. We investigated by checking out the access log to look for slow queries and saw that Quickr was running un-indexed queries that searched against cn, givenName, and displayName. These queries were taking about 30 seconds to run since the directory server had to do the DB equivalent of full-table scans. We checked the indexes and saw that displayName wasn’t indexed. After adding an index for the displayName attribute the queries were snappy, taking less than a second.