Re: Index on mail attribute does not work

2016-06-30 Thread Emmanuel Lécharny
Le 01/07/16 à 04:25, Ezsra McDonald a écrit :
> We had to rebuild our ADS using the plumber and the indexes did not build
> right.
>
> We removed the mail index from the partition and restarted the instance.
> Then we added a partition back and started it again. It takes a while but
> finally starts. We still can do wild card searches like we could before.
> They take a long time to run.
>
> ldapsearch -LLL -x -H ldap://localhost:10389/ -b
> "ou=People,dc=www,dc=somewhere,dc=com" "mail=*usern...@somewhere.com*"

This kind of search will not use an index, because you have '*' on both
sides of the String. It does a full scan.



Index on mail attribute does not work

2016-06-30 Thread Ezsra McDonald
We had to rebuild our ADS using the plumber and the indexes did not build
right.

We removed the mail index from the partition and restarted the instance.
Then we added a partition back and started it again. It takes a while but
finally starts. We still can do wild card searches like we could before.
They take a long time to run.

ldapsearch -LLL -x -H ldap://localhost:10389/ -b
"ou=People,dc=www,dc=somewhere,dc=com" "mail=*usern...@somewhere.com*"

ADS M20
Linux OS

This is pretty urgent if anyone can help.
--EZ