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
