At 12:20 PM 09/24/03, you wrote:
>unless you returned the WHOLE list from the query,
>otherwise, sorting on client side will result in incorrect dispaly.
>
>And in many cases, it's impossible to bring the WHOLE list to client side
>as the list is too large.

True in general; in this case, 100-200 records is not onerous.

>Also, sorting at client side may also cause memory usage to go up when the
>list is large.

True in general, however this data set is not large, and there's lots of MIPS and RAM on clients these days.

>Just let the database do the sorting and return the sub-set of list you care
>back to clients.

If there's a cheap way to offload "what-if" processing from a production database, it's a good idea.

TW

===========================================================================
To unsubscribe, send email to listserv@(protected)
of the message "signoff J2EE-INTEREST". For general help, send email to
listserv@(protected)".