An index for the server-side sort functionality

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 


[Index of Archives]     [Fedora User Discussion]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora News]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora QA]     [Fedora Triage]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Yosemite Photos]     [Linux Apps]     [Maemo Users]     [Gnome Users]     [KDE Users]     [Fedora Tools]     [Fedora Art]     [Fedora Docs]     [Maemo Users]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Fedora ARM]

  Powered by Linux