[389-users] Server side sort not using index

[Rich Megginson]

jim at scusting.com wrote:
> Hi,
>
> I noticed in our directory server logs a number of queries which are not 
> using indexes, and this appears to be down to sorting of the query being 
> done the server side:
>
> ----- Server sorted-------------
> conn=1433 op=1 SRCH base="o=blah.com" scope=2 
> filter="(&(accountid=abc123)(objectClass=dnszone)(dnstype=soa))" attrs=ALL
> conn=1433 op=1 SORT dnszonename (4)
> conn=1433 op=1 RESULT err=0 tag=101 nentries=1 etime=0 notes=U
>
> ----- Not sorted ----------
> conn=1440 op=1 SRCH base="o=blah.com" scope=2 
> filter="(&(accountid=abc123)(objectClass=dnszone)(dnstype=soa))" attrs=ALL
> conn=1440 op=1 RESULT err=0 tag=101 nentries=1 etime=0
>
> The 'accountid' field is indexed but when doing server side sorting it 
> seems to ignore this index - is this expected behaviour?  What options 
> do I have to ensure the index is used - just get the developers to sort 
> the results in their code rather than on the server?
>   
I think the problem is that the attribute dnszonename is not indexed.
> Thanks.
>
> Jim.
>
>
> --
> 389 users mailing list
> 389-users at lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/389-users
>