Andrey Ivanov
2008-Dec-09 13:51 UTC
[Fedora-directory-users] An index for the server-side sort functionality
Hi, There is a special type of indexing for the VLV sort searches but I have not found what sort of index I should create to make the server-side sort on a certain attribute optimized. Thank you Andrey Ivanov tel +33-(0)1-69-33-99-24 fax +33-(0)1-69-33-99-55 Direction des Systemes d''Information Ecole Polytechnique 91128 Palaiseau CEDEX France
Rich Megginson
2008-Dec-09 15:26 UTC
Re: [Fedora-directory-users] An index for the server-side sort functionality
Andrey Ivanov wrote:> Hi, > > > There is a special type of indexing for the VLV sort searches but I have > not found what sort of index I should create to make the server-side sort > on a certain attribute optimized. >I think each attribute you want to sort by must be indexed for equality.> > Thank you > > > Andrey Ivanov > tel +33-(0)1-69-33-99-24 > fax +33-(0)1-69-33-99-55 > > Direction des Systemes d''Information > Ecole Polytechnique > 91128 Palaiseau CEDEX > France > > -- > Fedora-directory-users mailing list > Fedora-directory-users@redhat.com > https://www.redhat.com/mailman/listinfo/fedora-directory-users >
Andrey Ivanov
2008-Dec-09 15:42 UTC
Re[2]: [Fedora-directory-users] An index for the server-side sort functionality
Tuesday, December 9, 2008, 4:26:08 PM, you wrote: RM> Andrey Ivanov wrote:>> There is a special type of indexing for the VLV sort searches but I have >> not found what sort of index I should create to make the server-side sort >> on a certain attribute optimized. >>RM> I think each attribute you want to sort by must be indexed for equality. No, it does not seem to be sufficient. I have activated all the indexes for the attribute (sn), the logs still show "notes=U" : [09/Dec/2008:16:36:38 +0100] conn=3817 op=3 RESULT err=0 tag=101 nentries=40 etime=0.004000 notes=U ... Maybe there is a special type of index for server-side sorting like the one for the VLV? Andrey Ivanov tel +33-(0)1-69-33-99-24 fax +33-(0)1-69-33-99-55 Direction des Systemes d''Information Ecole Polytechnique 91128 Palaiseau CEDEX France
Rich Megginson
2008-Dec-09 15:46 UTC
Re: [Fedora-directory-users] An index for the server-side sort functionality
Andrey Ivanov wrote:> Tuesday, December 9, 2008, 4:26:08 PM, you wrote: > > RM> Andrey Ivanov wrote: > >>> There is a special type of indexing for the VLV sort searches but I have >>> not found what sort of index I should create to make the server-side sort >>> on a certain attribute optimized. >>> >>> > RM> I think each attribute you want to sort by must be indexed for equality. > No, it does not seem to be sufficient. I have activated all the > indexes for the attribute (sn), the logs still show "notes=U" : > > [09/Dec/2008:16:36:38 +0100] conn=3817 op=3 RESULT err=0 tag=101 nentries=40 etime=0.004000 notes=U > > ... > > Maybe there is a special type of index for server-side sorting like > the one for the VLV? >No. Do you have any problems if you search on those attributes without server side sorting?> Andrey Ivanov > tel +33-(0)1-69-33-99-24 > fax +33-(0)1-69-33-99-55 > > Direction des Systemes d''Information > Ecole Polytechnique > 91128 Palaiseau CEDEX > France > >
Andrey Ivanov
2008-Dec-09 15:51 UTC
Re: [Fedora-directory-users] An index for the server-side sort functionality
2008/12/9 Rich Megginson <rmeggins@redhat.com>> Andrey Ivanov wrote: > >> Tuesday, December 9, 2008, 4:26:08 PM, you wrote: >> >> RM> Andrey Ivanov wrote: >> >> >>> There is a special type of indexing for the VLV sort searches but I have >>>> not found what sort of index I should create to make the server-side >>>> sort >>>> on a certain attribute optimized. >>>> >>>> >>> RM> I think each attribute you want to sort by must be indexed for >> equality. >> No, it does not seem to be sufficient. I have activated all the >> indexes for the attribute (sn), the logs still show "notes=U" : >> >> [09/Dec/2008:16:36:38 +0100] conn=3817 op=3 RESULT err=0 tag=101 >> nentries=40 etime=0.004000 notes=U >> >> ... >> >> Maybe there is a special type of index for server-side sorting like >> the one for the VLV? >> >> > No. > Do you have any problems if you search on those attributes without server > side sorting?No, not really. It''s more a request from our developers to simplify user sorting in their web applications. If i make the same search without the sorting the result is shown as indexed (no "notes=U") and takes two times less time : [09/Dec/2008:16:48:58 +0100] conn=3821 op=3 RESULT err=0 tag=101 nentries=40 etime=0.002000
Rich Megginson
2008-Dec-09 15:54 UTC
Re: [Fedora-directory-users] An index for the server-side sort functionality
Andrey Ivanov wrote:> > > 2008/12/9 Rich Megginson <rmeggins@redhat.com > <mailto:rmeggins@redhat.com>> > > Andrey Ivanov wrote: > > Tuesday, December 9, 2008, 4:26:08 PM, you wrote: > > RM> Andrey Ivanov wrote: > > > There is a special type of indexing for the VLV sort > searches but I have > not found what sort of index I should create to make > the server-side sort > on a certain attribute optimized. > > > RM> I think each attribute you want to sort by must be indexed > for equality. > No, it does not seem to be sufficient. I have activated all the > indexes for the attribute (sn), the logs still show "notes=U" : > > [09/Dec/2008:16:36:38 +0100] conn=3817 op=3 RESULT err=0 > tag=101 nentries=40 etime=0.004000 notes=U > > ... > > Maybe there is a special type of index for server-side sorting > like > the one for the VLV? > > > No. > Do you have any problems if you search on those attributes without > server side sorting? > > > No, not really. It''s more a request from our developers to simplify > user sorting in their web applications. > > If i make the same search without the sorting the result is shown as > indexed (no "notes=U") and takes two times less time : > > [09/Dec/2008:16:48:58 +0100] conn=3821 op=3 RESULT err=0 tag=101 > nentries=40 etime=0.002000It''s exactly the same search? Same base, scope, and filter?
Andrey Ivanov
2008-Dec-09 15:58 UTC
Re[2]: [Fedora-directory-users] An index for the server-side sort functionality
Bonjour Rich, Tuesday, December 9, 2008, 4:54:32 PM, you wrote:>> >> There is a special type of indexing for the VLV sort >> searches but I have >> not found what sort of index I should create to make >> the server-side sort >> on a certain attribute optimized. >> >> >> RM> I think each attribute you want to sort by must be indexed >> for equality. >> No, it does not seem to be sufficient. I have activated all the >> indexes for the attribute (sn), the logs still show "notes=U" : >> >> [09/Dec/2008:16:36:38 +0100] conn=3817 op=3 RESULT err=0 >> tag=101 nentries=40 etime=0.004000 notes=U >> >> ... >> >> Maybe there is a special type of index for server-side sorting >> like >> the one for the VLV? >> >> >> No. >> Do you have any problems if you search on those attributes without >> server side sorting? >> >> >> No, not really. It''s more a request from our developers to simplify >> user sorting in their web applications. >> >> If i make the same search without the sorting the result is shown as >> indexed (no "notes=U") and takes two times less time : >> >> [09/Dec/2008:16:48:58 +0100] conn=3821 op=3 RESULT err=0 tag=101 >> nentries=40 etime=0.002000RM> It''s exactly the same search? Same base, scope, and filter? Yes. Exactly the same. The only difference is the search control for server-side sorting over sn. With this control : [09/Dec/2008:16:55:59 +0100] conn=3826 op=3 SORT sn;2.16.840.1.113730.3.3.2.11.1 (59) [09/Dec/2008:16:55:59 +0100] conn=3826 op=3 RESULT err=0 tag=101 nentries=40 etime=0.004000 notes=U Andrey Ivanov tel +33-(0)1-69-33-99-24 fax +33-(0)1-69-33-99-55 Direction des Systemes d''Information Ecole Polytechnique 91128 Palaiseau CEDEX France
Rich Megginson
2008-Dec-09 16:00 UTC
Re: [Fedora-directory-users] An index for the server-side sort functionality
Andrey Ivanov wrote:> Bonjour Rich, > > Tuesday, December 9, 2008, 4:54:32 PM, you wrote: > > > >>> There is a special type of indexing for the VLV sort >>> searches but I have >>> not found what sort of index I should create to make >>> the server-side sort >>> on a certain attribute optimized. >>> >>> >>> RM> I think each attribute you want to sort by must be indexed >>> for equality. >>> No, it does not seem to be sufficient. I have activated all the >>> indexes for the attribute (sn), the logs still show "notes=U" : >>> >>> [09/Dec/2008:16:36:38 +0100] conn=3817 op=3 RESULT err=0 >>> tag=101 nentries=40 etime=0.004000 notes=U >>> >>> ... >>> >>> Maybe there is a special type of index for server-side sorting >>> like >>> the one for the VLV? >>> >>> >>> No. >>> Do you have any problems if you search on those attributes without >>> server side sorting? >>> >>> >>> No, not really. It''s more a request from our developers to simplify >>> user sorting in their web applications. >>> >>> If i make the same search without the sorting the result is shown as >>> indexed (no "notes=U") and takes two times less time : >>> >>> [09/Dec/2008:16:48:58 +0100] conn=3821 op=3 RESULT err=0 tag=101 >>> nentries=40 etime=0.002000 >>> > RM> It''s exactly the same search? Same base, scope, and filter? > > Yes. Exactly the same. The only difference is the search control for server-side > sorting over sn. With this control : > [09/Dec/2008:16:55:59 +0100] conn=3826 op=3 SORT sn;2.16.840.1.113730.3.3.2.11.1 (59) > [09/Dec/2008:16:55:59 +0100] conn=3826 op=3 RESULT err=0 tag=101 nentries=40 etime=0.004000 notes=U >Ok. I''m not sure what''s going on then.> > Andrey Ivanov > tel +33-(0)1-69-33-99-24 > fax +33-(0)1-69-33-99-55 > > Direction des Systemes d''Information > Ecole Polytechnique > 91128 Palaiseau CEDEX > France > >