FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Redhat > Fedora Directory

 
 
LinkBack Thread Tools
 
Old 03-23-2010, 11:20 AM
"jim@scusting.com"
 
Default Server side sort not using index

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?

Thanks.

Jim.


--
389 users mailing list
389-users@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/389-users
 
Old 03-23-2010, 03:22 PM
Rich Megginson
 
Default Server side sort not using index

jim@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@lists.fedoraproject.org
> https://admin.fedoraproject.org/mailman/listinfo/389-users
>

--
389 users mailing list
389-users@lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/389-users
 

Thread Tools




All times are GMT. The time now is 12:51 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org