George Daswani wrote: > Hello, > > I have around 350K users in my test directory, and I'm running > into an odd problem with the directory not using indeces for > ldapsearches. > > For example, using the following search string > > (&(objectClass=organizationalPerson)(employeeNumber=*)) > > Looking at the console, there's a system index on objectClass (which is > set to equality), there's also an index on employeeNumber (both equality, > and presence). > > There are around 5K icasOrgPersons (which can hold the employeeNumber > attribute), the rest can't. How many entries match (objectClass=organizationalPerson)? If this number is large, then I think what's happening is that the database first looks up how many match this, and says there are too many. Try using icasOrgPerson or reverse the order of the filters. > When the actual search (really slow as if it > was using a full scan) is performed, the access log files shows "notes=U" > meaning that the search was unindexed. The question is why considering > there were indeces built for the attributes in the search filter? > > Thanks. > > > > > > > -- > Fedora-directory-users mailing list > Fedora-directory-users at redhat.com > https://www.redhat.com/mailman/listinfo/fedora-directory-users > -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/x-pkcs7-signature Size: 3178 bytes Desc: S/MIME Cryptographic Signature Url : http://lists.fedoraproject.org/pipermail/389-users/attachments/20060802/bb0bb9d4/attachment.bin
