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 > > -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/x-pkcs7-signature Size: 3258 bytes Desc: S/MIME Cryptographic Signature Url : http://lists.fedoraproject.org/pipermail/389-users/attachments/20081209/fab898c6/attachment.bin