Re: large queries

From: Thomas Kellerer <YQDHXVLMUBXG@xxxxxxxxxxxxx>
Date: Wed, 23 Apr 2008 08:21:21 +0200

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 documentation, maybe the driver is first caching the complete result set in memory before delivering it to the caller.

Thomas
.

Follow-Ups:
- Re: large queries
  - From: Arne Vajhøj

References:
- large queries
  - From: Terry

Prev by Date: Flexibility - Having work wear is an important part of your career and day, but you may find that what you need is the flexibility offered by your work wear. Having flexibility is a great benefit to the average person. You can do more things comfortably when you have the added bonus of flexibility.
Next by Date: Re: Precompiled statement?
Previous by thread: Re: large queries
Next by thread: Re: large queries
Index(es):
- Date
- Thread