[Fedora-directory-users] An index for the server-side sort functionality

[Andrey Ivanov]

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


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