Searching a ResultSet

[Steve Dyke]

I am using java sql to get remote record data. After I get the ResultSet is there a faster way to searh for the existance of a string within the ResultSet other than iterating through the records with while loop?

[Istvan Kovacs]

Steve Dyke wrote:I am using java sql to get remote record data. After I get the ResultSet is there a faster way to searh for the existance of a string within the ResultSet other than iterating through the records with while loop?

I don't know of any. Maybe you should change your SQL query to make the information you need more readily available?

[Nevin kumar]

You can try Google's java collections,lambdaj features. you can apply filtering on all sort of collections.

[David Newton]

@Nevin: won't be any faster, though, just cleaner.

@Steve: no. As Istvan said, maybe querying better would be a cleaner solution.

[Manish Singh]

Fastest possible way would be an exact query to be sent to the DB. as the DB might make use of proper indexing and the unnecessary data wont travel from DB to the java machine.

[Rob Spoor]

I agree with Istvan and Manish. Let the database server do the hard work, and as a bonus get less results so less network traffic.