Re: large queries

Terry, 22.04.2008 20:39:
> 
> Hi,
> 
> Can anyone make a recommendation on how
> to design a Java system that will make SQL
> queries on a mySQL database that results in very
> large data sets?  What can be done to improve
> performance?  Is hybernate better than using
> straight JDBC?

I find hibernate is lot more complicated to be used in such a situation. 
Straight JDBC gives you a lot more control over what is beeing fetched. 

The question is: what do you want to do with the data set? 
The strategies for displaying large data sets to the end user are
completely different than processing large data sets in the backend.

Check the driver do***entation, maybe the driver is first caching the
complete result set in memory before delivering it to the caller. 

Thomas