Andrey Ivanov wrote: > > > 2008/12/9 Rich Megginson <rmeggins at redhat.com > <mailto:rmeggins at 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 It's exactly the same search? Same base, scope, and filter? -------------- 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/b4ce2c98/attachment.bin
