When return huge amount of data to java based application, What are the guild lines and strategy sho

[sanjey asok]

When return huge amount of data to java based application,
What are the guild lines and strategy should be followed?

[Jeanne Boyarsky]

A few ideas:
1) Don't return any columns you don't need.
2) Return the data in batches. (Also consider what you are doing with the data and why you need so much. Unless you are downloading a huge report, you may need less data than you first think.)
3) Test the performance early to see how it meets your expectations.

[sanjey asok]

Return the data in batches

Is very interesting please explain how it will be implemented

[Jeanne Boyarsky]

You have a primary key for your table/data. Suppose it is a number. You could add a clause to say you only want records 1-1000, 1000-2000, etc. That way your code controls what data is returned.