[Date Prev][Date Next]
Re: Plea for Server Side Sorting
- To: Dave Horsfall <email@example.com>, OpenLDAP Software List <openldap-software@OpenLDAP.org>
- Subject: Re: Plea for Server Side Sorting
- From: Owen DeLong <firstname.lastname@example.org>
- Date: Thu, 31 Mar 2005 16:41:55 -0800
- In-reply-to: <20050401093607.C74324@mippet.ci.com.au>
- References: <email@example.com> <20050401093607.C74324@mippet.ci.com.au>
--On Friday, April 1, 2005 9:37 AM +1000 Dave Horsfall <firstname.lastname@example.org>
> On Thu, 31 Mar 2005, Eric Nichols wrote:
>> Server side sorting is a huge gain for LDAP application programmers
>> (like myself). It saves the effort of having to store the results (in
>> memory) in order for them to be sorted. I guess the equivalent would be
>> like not having sorted results for SQL queries.
> Except the client (SQL) performs the sorting, not the server...
Huh? I think not, given that the client can request the first N results
from the server in sorted order. Also, the client can request grouping,
and other things from the server that require server side sorting. In fact,
SQL can even subtotal columns by groups for you on the server side.
Sure, you can get unsorted result sets and sort them yourself from SQL, but,
SQL does require server side sorting in a complete implementation. Oracle,
Sybase, and MySQL all provide server side sorting.
> Dave Horsfall DTM VK2KFU email@example.com Ph: +61 2 8425-5508 (d)
> -5500 (sw) Corinthian Engineering, Level 1, 401 Pacific Hwy, Artarmon,
> NSW 2064, Australia
If it wasn't crypto-signed, it probably didn't come from me.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (Darwin)
-----END PGP SIGNATURE-----