Re: large queries

In article <480e30fb$0$12950$4c368faf@[EMAIL PROTECTED]
>, Terry
<list@[EMAIL PROTECTED]
> wrote:
>
>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?
>
>
>Thanks,
>
>Terry

The best way to improve performance is to have small result sets. Do you 
really need large results? Can you partition your queries? 

Try to minimize things going across the network. I don't like stored 
procedures, but you may need to consider them.

I don't think Hinernate will help you much for this.

Assuming large is really large, and you are talking about the query
result, 
not the size of the database.

Eric