If this is a read-only operation then sorting it in memory would be much better than issuing another query.
Patrick -----Original Message----- From: Repine, Burt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 6:02 PM To: JDJList Subject: [jdjlist] sorting records Hello all - I have a requirement to retrieve n number of records from a database using JDBC and then display those records to the user. The user can then sort those records if they so choose. Would it be faster/less resource intensive to go back to the database with a new 'order by' SQL statement OR sort the records as a Collection in the Java code? Thanks for the help, Burt To change your membership options, refer to: http://www.sys-con.com/java/list.cfm To change your membership options, refer to: http://www.sys-con.com/java/list.cfm
